Hi Misty,

Another thing I thought of...

If your other drop downs will be identical to eachother, then you could just
refer to the cells that hold the drop downs, and the cell that holds the
formula.

Meaning, if your drop downs and offset formula are in a1:c1, then in cell
a10, type in =a1, in cell b10 type in =b1, in cell c10 type in =c1

Hope that answers your question.