Forum Discussion
Excel Drop Down List conditions
Hi All,
I need to learn how to do something in excel that im unsure of.
I need to set up 2 drop down lists, so that depending on what conditions are ticked in the list, a third field populates with a predefined value that I set up
Hia,
My preference for this would be to use an 'index match match' to look up the result from a table of options.
I've attached an example
