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