I am not sure that validation will work given what I need. I have 2 columns. One column is an identifier column and one has the information that I want input into the cell. As an example, column 1 contains a list of ingredients. Column 2 contains the cost per ounce of the ingredients. I want to be able to select the ingredient and have it input the cost. Is this possible with validation?

Thank you!