Forum Discussion
rbctg
Jan 10, 2022Copper Contributor
use drop down to sort
How do I have a drop-down from 50 states to assign them to one of two language choices (English or Spanish)? That result needs to be later input to a choice of a trainer which should then populate a hourly rate. Is this best done by a function or a different command?
For example, I’m in New Mexico and need an English trainer. The field shows me I have a choice of Rob or Karen at either $60 p/h or $65 p/h.
Location – language - trainer – cost
Thanks
2 Replies
- NikolinoDEPlatinum Contributor
for examble:
How to create dependent cascading drop down list in Excel?
Standard Disclaimer: These are links to non-Microsoft websites.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
- rbctgCopper ContributorI'll give it a shot! Thank you very much!!