Using "Vlookup" across 2 Spreadsheets

  • Thread starter Thread starter wormburner
  • Start date Start date
W

wormburner

I am trying to create a spreadsheet that takes a value from cell 6 of
"Product Price Levels" if the value in cell A4 of my working spreadsheet is
found in the range between A8 and I3000 of the "Product Price Levels" spread
sheet.

I receive a "#N/A" error and I do not know why.

Formula as it is written:
=VLOOKUP($A$4,'Product Price Levels.xls'!$A$8:'Product Price
Levels.xls'!$I$3000,6,FALSE)

Can you use "Vlookup" across 2 spreadsheets? If not, what do you suggest?

Thanks
 
Hi,
could you post an example, cell 6 ?? which column??, anyway vlookup works
looking into the first column, an example will help to get you a formula
 
Your cell referencing is incorrect.

=VLOOKUP($A$4,'Product Price Levels'!$A$8:$I$3000,6,FALSE)

Sheet name only needs to appear once, and don't put the ".xls" extension in
there.
 
Back
Top