Vlookup returning 0 instead of #N/A

onthegreen03

Board Regular
Joined
Jun 30, 2016
Messages
78
Office Version
  1. 365
Platform
  1. Windows
I have a table with either numbers or #N/A in the cells. I am writing a simple VLOOKUP formula to grab data from that table, the problem is when the result is #N/A the formula returns 0 (zero). How can I get the formula to return what is in the cell, whether its a number or #N/A? Thanks!
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
11,626
Office Version
  1. 365
Platform
  1. Windows
It should return whatever is in the cell, if it is not then it means that the formula is not matching to the row that you think it is.
 

onthegreen03

Board Regular
Joined
Jun 30, 2016
Messages
78
Office Version
  1. 365
Platform
  1. Windows
It should return whatever is in the cell, if it is not then it means that the formula is not matching to the row that you think it is.
Thanks, I'll recheck my formula. I appreciate the response.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,023
Messages
5,575,631
Members
412,680
Latest member
TSpan
Top