Remove #N/A from vlookup

[brandon16]

Hi,

How do I return a blank or 0 instead of #NA from my vlookup below please?

=VLOOKUP(C35,'Tab 2'!$B$31:$G$95,3,FALSE)

 

[Jonmo1]

If you have XL2007+, try the IFNA function..

=IFNA(VLOOKUP(C35,'Rate Card'!$B$31:$G$95,3,FALSE),"")

 

[Jonmo1]

Correction, IFNA wasn't available until XL2013. Otherwise, try IFERROR instead (same syntax, just change IFNA to IFERROR)

 

[brandon16]

That worked, thank you

 

[Jonmo1]

You're welcome.