I want users to type in a part number in one cell "A1" then in cell "A2" I
would like the description of the part to appear. In cell A3 the price of
part should show up, etc
I have set so part numbers are on a master sheet (column A) with description
(column B) and Price (column C), etc beside. Each seperate sheet in file
uses different part combinations. I need the formula to "hunt" for the part
number in a range and return the corresponding values in the adjacent cells.
Example typing number PT1(part 1) in cell A1 returns corresponding part 1
description in cell B1 and part price in Cell C1. The tricky part is that if
in cell A2 I type a part number that isnt the second part in the parts master
list then the statements does not work. I realize that I will have to have
separate statements for columns b & C. Please help