Cells A1, A2, A3 are validated lists. I want cell C1 to populate
with the correct $$ (data located on hidden cells on same
worksheet)depending on which list (A1, A2 or A3) you choose product from.
What is best method for getting a cell to hold multiple formulas?