Forum Discussion
Dropdown List Referencing Other Cells
I've created a dropdown list with only three options in cell O24.
Gold
Silver
Waive
In cell P24, I'd like to Create a formula so when Gold is chosen, it only references the data in P23; Silver only references data in Q23 and Waive = 0.
Can you kindly assist?
2 Replies
=IF(O24="Gold",P23,IF(O24="Silver",Q23,IF(O24="Waive",0)))You can try this nested IF formula in cell P24.
- I can't thank you enough OliverScheurich! Worked flawlessly and I'm grateful for you taking the time to respond.
