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
Bookmarks