Posted to microsoft.public.excel.worksheet.functions
|
|
VLOOKUP returns #N/A
See this:
http://contextures.com/xlFunctions02.html#Trouble
--
Biff
Microsoft Excel MVP
"fbagirov" wrote in message
...
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!
|