Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error in VLOOKUP
I am trying to get Excel to look up what is in a column in a one worksheet
and find it in another worksheet and come back with what is in a different column for the same row. Example: I have one worksheet with names in one column (column I, file 1), I want Excel to search in file 2 to find what is in column I row 2 and return what is in column DH in file 2 for that name. I keep getting either a reference error or an #NA error. Below is the formula I entered: =VLOOKUP(I20, '[Excel Report MI.xls]Data Entry'!$A$13:$DH$68, 112, FALSE) What am I doing wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup() error #n/a | Excel Worksheet Functions | |||
Vlookup and #N/A error | Excel Worksheet Functions | |||
VLookup N/A Error | Excel Discussion (Misc queries) | |||
Value Not Available Error in Vlookup | Excel Discussion (Misc queries) | |||
Vlookup Error | Excel Worksheet Functions |