Forum Discussion

BeverlyHV's avatar
BeverlyHV
Copper Contributor
May 27, 2022
Solved

Drop Down List formula based on data in a different cell

I wrote a formula for a drop down list based on the data of another cell (see below). What am I missing?   The drop down list should be the percentages if the data in another cell is a specific res...
excel
  • mathetes's avatar
    mathetes
    May 27, 2022

    BeverlyHV 

     

    Attached is what I've called a cascading data validation (AKA drop down). See if you can follow the approach used there. It does depend on your having the most current version of Excel

mathetes's avatar
mathetes
Gold Contributor
May 27, 2022

BeverlyHV 

 

Attached is what I've called a cascading data validation (AKA drop down). See if you can follow the approach used there. It does depend on your having the most current version of Excel

Resources