Share via

Excel: Make a two cell drop down list

Anonymous
2024-11-19T21:23:02+00:00

Need help figuring out how to make a two cell drop down list ; one is for a textual response (like "Fully Funded") and the other is a value (like 100%) later compiled, (or "Partially Funded" and 75%). I have the Data Validation values, but need to put them into the form for users to pick the from the Textual value and then populate the numerical.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2024-11-19T21:33:36+00:00

Jonathon,

A drop down list accompanied by an xlookup (or vlookup for older versions) to assign the Numerical value to each selection may work.

Mike

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-11-19T22:26:40+00:00

    THANK YOU Mike!

    Was this answer helpful?

    0 comments