Hello

I have a spreadsheet of a rather large stocklist. I use this to check off
the price charged on the invoice when we receive the goods, against the
quoted buy price in the spreadsheet. Column A3 - A8000 (ish) contains a
product code; B3 = description; C3 = buy price; D3 = sell price; E3 = Profit
margin, etc.

What I would like to do to make this job of checking the prices off more
efficient, is to type in the product code of the item i am checking in say,
A2, and have the corresponding information appear. Is this possible???

Any help would be greatly appreciated. Thank you