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


On Apr 6, 1:42 am, "Ed Davis" wrote:
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