vlookup

[donman1950]

When the vlookup foprmula does not see the lookup referenced cell i
returns the value for the cell above.

for example if the vlookup formula is looking for Apple and it is no
in the worksheet that it is looking, it returns the value for th
previous cell. See attachment

How do I correct that?

thank

Attachment filename: excel example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=64664

 

[JE McGimpsey]

If you had looked at Help, you would have found the fourth argument for
VLOOKUP that determines whether the match is to be exact or approximate.

You can use

=VLOOKUP(D1,A:B,2,FALSE)

to return either an exact match or #N/A.

if you'd rather have a non-match appear to be blank, use

=IF(ISNA(MATCH(D1,A:A,FALSE)),"",VLOOKUP(D1,A:B,2,FALSE))