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

BeverlyHV's avatar
BeverlyHV
Copper Contributor
May 30, 2022

BeverlyHV 

 

As a follow up, I believe I have the formula correct, however the entire formula is showing in the drop down list. How do I fix the formula so only the actual list (percentages) show as options based on the rating in a different cell.

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 30, 2022

    BeverlyHV 

    You should follow the example posted by Mathetes: using a range as source instead of a text string.

Resources