Jason,

It may have to do with typing out the sheet1!

make it easy on yourself. Click into Sheet1 and highlight the entire
range of product names and product prices. Once highlighted, name the
range "pricelist." (you name a range by clicking into the box to the
left of the formula entry line that should indicate the cell you are
in, or the range you have selected....in this case the box should read
"A1:B10000" or whatever. Click in there and type instead "pricelist").
Now that range has a name insted of a number that can be used in any
other workbook in the spreadsheet.

Now go to sheet 2 and select the first cell that you want a price to be
entered. Type "=vlookup([click on the cell to the left],pricelist,2).

note the "2" tells Excel to return the value in the 2nd column next to
the matching product name.....you could add 10 other columns to your
price list (rename it using all 10 columns) and then change your
vlookup formula to return the value, it say, the sixth column
instead...\

hope this helps


---
Message posted from http://www.ExcelForum.com/