Using "Vlookup" across 2 Spreadsheets
 

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

Using "Vlookup" across 2 Spreadsheets
 

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

"wormburner" wrote:

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

Using "Vlookup" across 2 Spreadsheets
 

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.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"wormburner" wrote:

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