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