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.