Remove #N/A from vlookup

brandon16

Board Regular
Joined
Sep 29, 2014
Messages
112
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)
 
Last edited:

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
If you have XL2007+, try the IFNA function..

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

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Correction, IFNA wasn't available until XL2013. Otherwise, try IFERROR instead (same syntax, just change IFNA to IFERROR)
 

Forum statistics

Threads
1,086,120
Messages
5,387,964
Members
402,091
Latest member
thomastsiakis

Some videos you may like

This Week's Hot Topics

Top