Vlookup

[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

 

[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

 

[Dave Peterson]

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

 

[Ed Davis]

Thank you Dave
That worked great.

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

 

[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