If Cell Value equals “X”, then enter descrition and price in adjacent cells

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.  

For example: 

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

Leave a Reply

Your email address will not be published. Required fields are marked *