I have eight different product numbers with unique descriptions and prices. In order to reduce or eliminate order entry errors, I would like write a formula that when one of the eight item numbers is entered in column A, the corresponding item description will then populate column B and price in Column C.
If Item “11111” is entered in column A1, then Column B1 will populate with the description “Copo Red Brake Caliper” and Column C1 will populate with “$250”
Next, If item “12111” is entered in A2, then Column B2 will populate with the description “Copo Blue Brake Caliper” and Column C2 will populate with “$265”
and so on…
By: Tom Coppo