Dropdown List Referencing Other Cells

Copper Contributor

I've created a dropdown list with only three options in cell O24.  






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



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.