Vlookup

E

Ed Davis

Does anyone know how (when using vlookup) to only show a values if it
exists.
Example
Table looks like this

1245 betty
1249 joey


when I enter 1265 it should show nothing or "Not In Table"


Thanks in advance
ED
 
P

Pete_UK

Generally,

=IF(ISNA(vlookup_formula),"Not present",vlookup_formula)

Your vlookup_formula should have FALSE or 0 as the 4th argument so
that you are looking for an exact match.

Hope this helps.

Pete
 
D

Dave Peterson

=if(isna(match(a1,sheet2!a:a,0)),"not in table",vlookup(a1,sheet2!a:b,2,false))
 
P

Pete_UK

Hi Ed,

try this:

=IF($A7=0,"",IF(ISNA(VLOOKUP($B7,$K$6:$Q$199,3,0)),"not
present",VLOOKUP($B7,$K$6:$Q$199,3,0)))

All one formula - beware of line wraps.

Hope this helps.

Pete
 
Top