Forum Discussion

BrookeCova's avatar
BrookeCova
Copper Contributor
Feb 14, 2023

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; S...
excel
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Feb 14, 2023

BrookeCova 

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

You can try this nested IF formula in cell P24.

  • BrookeCova's avatar
    BrookeCova
    Copper Contributor
    Feb 14, 2023
    I can't thank you enough OliverScheurich! Worked flawlessly and I'm grateful for you taking the time to respond.

Resources