Hi

I have been asked to create a spreadsheet and one part of the spreadsheet sees me input the commercial name of a product (lets call them Product A, B C and D). Each of these products have an active ingredient in them - Ingredient A, B, C and D. These active ingredients need to be inputted into the adjacent column each time i enter the products name.

What i need to know is how can i get it so when an entry is made in one column listing the product sold (ie Product B) the next column automatically inputs the respective active ingredient (Ingredient B).

I have tried IF formulas but i think I am looking down the wrong path.

Any assistance would be massively appreciated.

Chris