on in D1 of sheet 2 enter
=vlookup(B1,'Sheet1'!A:B,2,0)

"pblake" wrote:

I hope this makes sense...
I have a sheet in workbook, with column A listing data, and column B listing
the corresponding price.

On another page, I would like to enter data, and have the prices come up.

On page 2, if B1=L5301, I want D1 to pull the price page 1 in the workbook.