Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup bringing back #N/A
This is my formula:
=VLOOKUP(A1,'[Czech Republic IDP''s for 2007_5-21-07.xls]Month by Month'!$A$1:$H$11,2,FALSE) A1 is spelt exactly the same (May) in the lookup spreadsheet and is is the first column, but it brings back #N/A What might be wrong? thanks for any advise Afsha |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup bringing back #N/A
Check there are no extra blanks in the data.
"Afsha" wrote: This is my formula: =VLOOKUP(A1,'[Czech Republic IDP''s for 2007_5-21-07.xls]Month by Month'!$A$1:$H$11,2,FALSE) A1 is spelt exactly the same (May) in the lookup spreadsheet and is is the first column, but it brings back #N/A What might be wrong? thanks for any advise Afsha |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup bringing back #N/A
What's in A1--is it a date formatted to only show the month?
How about in the table? Maybe the dates are really different (may 22 vs may 18???) If it's just text, look for leading/trailing spaces in either/both locations. Afsha wrote: This is my formula: =VLOOKUP(A1,'[Czech Republic IDP''s for 2007_5-21-07.xls]Month by Month'!$A$1:$H$11,2,FALSE) A1 is spelt exactly the same (May) in the lookup spreadsheet and is is the first column, but it brings back #N/A What might be wrong? thanks for any advise Afsha -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I fetch multiple rows back using VLOOKUP? | Excel Worksheet Functions | |||
bringing data in from another worksheet | Excel Discussion (Misc queries) | |||
bringing data in from one worksheet to another | Excel Worksheet Functions | |||
Bringing quotations back up on screen | Excel Discussion (Misc queries) | |||
Bringing together data | Excel Worksheet Functions |