Thread
:
VLOOKUP and #N/A
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
RJ
external usenet poster
Posts: 40
VLOOKUP and #N/A
How do I do a VLOOKUP and return nothing instead of #N/A?
For instance, if I have D1= "=VLOOKUP(C1,$A$1:$B$3,2,FALSE)"
Instead of #N/A I would rather get nothing.
A B C D
1 5 Red 3 #N/A
2 10 Blue 5 Red
3 15 Green 15 Green
4
Reply With Quote
RJ
View Public Profile
Find all posts by RJ