Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP returns #REF!
I am trying to do a vlookup where my initial list is in the middle of a
spread sheet. I took that list an opened another sheet and made the list the first column of that spread sheet, but I can't get it to work. -- DMM |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP returns #REF!
sounds like the reference to the range is incorrect - can you post the actual
VLOOKUP formula you are using? "soconfused" wrote: I am trying to do a vlookup where my initial list is in the middle of a spread sheet. I took that list an opened another sheet and made the list the first column of that spread sheet, but I can't get it to work. -- DMM |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP returns #REF!
VLOOKUP(Sheet1!A2:A34,[0308_WIP_Pump_Load_MonthMEC.xls]PumpSch!$Q$5:$U$26,17,TRUE)
-- DMM "AdamV" wrote: sounds like the reference to the range is incorrect - can you post the actual VLOOKUP formula you are using? "soconfused" wrote: I am trying to do a vlookup where my initial list is in the middle of a spread sheet. I took that list an opened another sheet and made the list the first column of that spread sheet, but I can't get it to work. -- DMM |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP returns #REF!
You can only lookup one item at a time
VLOOKUP(this_value, in _this_table< return_this_column_itme, true/false for exact) ' And the second file in your lookup must be opne best wishes -- www.stfx.ca/people/bliengme "soconfused" wrote: VLOOKUP(Sheet1!A2:A34,[0308_WIP_Pump_Load_MonthMEC.xls]PumpSch!$Q$5:$U$26,17,TRUE) -- DMM "AdamV" wrote: sounds like the reference to the range is incorrect - can you post the actual VLOOKUP formula you are using? "soconfused" wrote: I am trying to do a vlookup where my initial list is in the middle of a spread sheet. I took that list an opened another sheet and made the list the first column of that spread sheet, but I can't get it to work. -- DMM |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP returns #REF!
And there are not 17 columns in the range $Q$5:$U$26; there are only 5
Tyro "Bernard Liengme" wrote in message ... You can only lookup one item at a time VLOOKUP(this_value, in _this_table< return_this_column_itme, true/false for exact) ' And the second file in your lookup must be opne best wishes -- www.stfx.ca/people/bliengme "soconfused" wrote: VLOOKUP(Sheet1!A2:A34,[0308_WIP_Pump_Load_MonthMEC.xls]PumpSch!$Q$5:$U$26,17,TRUE) -- DMM "AdamV" wrote: sounds like the reference to the range is incorrect - can you post the actual VLOOKUP formula you are using? "soconfused" wrote: I am trying to do a vlookup where my initial list is in the middle of a spread sheet. I took that list an opened another sheet and made the list the first column of that spread sheet, but I can't get it to work. -- DMM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Returns a zero value | Excel Discussion (Misc queries) | |||
VLOOKUP returns #REF!? | Excel Discussion (Misc queries) | |||
VLOOKUP returns #N/A | New Users to Excel | |||
VLOOKUP Returns #REF | Excel Worksheet Functions | |||
vlookup returns n/a | Excel Worksheet Functions |