VLOOKUP returns #N/A

F

fbagirov

I have 2 workseets - A and B

Spreadsheet A and B have columns (column C and column A, respectively) with
similar values.

The formula in column D of spreadsheet A has formula:
=if(iserror(VLOOKUP(C2, B!$A$1:$B$100,2,FALSE)),"Not Available",VLOOKUP(C2,
B!$A$1:$B$100,2,FALSE))

Spreadsheet B has a table with 2 columns - column A has values similar to
column A!C, column B has target values.

Column A!D shows #N/A, even though values in A!C and B!A match!
I sorted B!A1:B100 out, I made it General type, and I manually tracked
several values, they should be looked up by the formula, but A!D still shows
#N/A!!

Anybody can help ? Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top