Vlookup, return empty cell (not #N/A) when result not found

Hello,

Sorry for bugging you guys but I have a quick problem. I have a list of words which consists of words. I want to search for a particular word from this list and when the word isnt found, I want an output of an empty space in the cell (" "). Below is what I have

A B
1
2 yes_1 Hello
3 yes_2 Goodbye
4 xxx Hi
5 xxx Try

My code at cell A9 is:

=VLOOKUP("yes_3",$A$36:$G$53,7,FALSE)

Instead of an output of #N/A....how do i get the cell to show a blank cell?

Once again thank you for your time.

Try this:

=IF(ISNA(VLOOKUP("yes_3",$A$36:$G$53,7,FALSE)), "", VLOOKUP("yes_3",$A$36:$G$53,7,FALSE))

HTH

Jason

This question has been answered a zillion times on this forum. Remember we have a very nice Search tool available .

Sorry ARTH....i'll make sure to use the search next time!

No worries mate !