#N/A not required

[hsandeep]

while vlookup, I get #N/A. How to get null ("") instead of #N/A.
Please suggest alongwith an example/formula.
Regards

 

[VoG]

Try like this

=IF(ISNA(VLOOKUP(A1,B1:C20,2,FALSE)),"",VLOOKUP(A1,B1:C20,2,FALSE))

 

[Skybluekid]

For 2007 onwards use IFERROR(VLOOKUP(B2,C2:A5,2,0), "")

 

[hsandeep]

Thanks to both. I am using 2007. So I should use Skybluekid. Am I CORRECT or WRONG? Just tell me back.

 

[VoG]

You are correct.