drop down cells

Occasional Visitor


I have a cell with a drop down menu and I need to get another cell to changed for the different items on the menu how can I do this (there is a different formula for each drop down item)

thank you

3 Replies



Create a drop-down list



I would be happy to know if I could help.



I know I don't know anything (Socrates)





If you have the drop-down in A1
You could have something like this in your “target” cell.
The “target” will show the result of different formulas depending on what you chose in the dropdown (x or y)

If I can recommend you, add a file (without sensitive data) and describe your plan on it. This means that you can be helped more quickly and the best possible solution tailored to your needs can be offered. So everyone is helped.
Help to be helped.

* It's always good to add your operating system and Excel version.

I know I don't know anything (Socrates)