I need VLOOKUP to return Blank cell instead of N/A

[elkhntr4]

I have the following formula:

=(VLOOKUP(A18,Sheet2!$A15:B26,2,FALSE))

I need it so that if i dont have anything selceted from a dropdown in that row, it will return Blank instead of N/A.

Thanks in advance.

[Fotis1991]

As i see that you use Excel 2003, try with ISNA function in front of your formula.

[Ace_XL]

=IF(A18="","",(VLOOKUP(A18,Sheet2!$A15:B26,2,FALSE))
or
=if(isna(VLOOKUP(A18,Sheet2!$A15:B26,2,FALSE)),"",(VLOOKUP(A18,Sheet2!$A15:B26,2,FALSE))

[elkhntr4]

Problem Solved! Thanks guys!

[xandermacleod]

Its not the most elegant solution but perhaps:

=IF(ISERROR(your vlookup formula), "", (your vlookup formula)

[Pete_UK]

Another one:

=IF(COUNTIF(Sheet2!A15:A26,A18)=0,"",VLOOKUP(A18,Sheet2!$A15:B26,2,FALSE))

I would suggest that you use absolute addressing for your table references, as well.

Hope this helps.

Pete