Vlookup returning N/A

[paul_r26]

Hi All,

Have a nightmare with vlookup today, if the lookup returns nothing, rather than showing N/A I need it to show nothing. I can't seem to work it out.

The working formula is:
"=VLOOKUP(A5,'DATA APRIL'!$J$2:$R$5000,9,FALSE)"

 

[shaowu459]

what the version of excel you are using? if you have versions higher than Excel 2003, you can use:
=IFERROR(VLOOKUP(A5,'DATA APRIL'!$J$2:$R$5000,9,FALSE),"")

 

[paul_r26]

Thank you, perfect, I was typing If not iferror!