I have a price list and want to set something up, so that when I type a code
of a product in, it will automatically bring up the price.
So for example I type in A1234, I want it to automatically bring up the
price from price list on another sheet (the sheet is in the same workbook).
It doesn't matter if the price shows in the same cell or a different cell.
Is there anyway that I can do this?