Vlookup returning 0 instead of #N/A

[onthegreen03]

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!

 

[jasonb75]

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]

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.