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