This sounds like a pretty easy process. Can you provide more info? What
lists are in cells A1:A3? What data is located on hidden cells? Are they
lookup tables depending on what is selected? What cell do you want to hold
multiple formulas?

Steve


"Joyce" wrote in message
...
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?