Dropdown List Referencing Other Cells

[BrookeCova]

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]

@BrookeCova 

=IF(O24="Gold",P23,IF(O24="Silver",Q23,IF(O24="Waive",0)))

You can try this nested IF formula in cell P24.

[#3]

I can't thank you enough @OliverScheurich! Worked flawlessly and I'm grateful for you taking the time to respond.