Beatrice
Board Regular
- Joined
- Sep 17, 2019
- Messages
- 85
- Office Version
- 2019
- Platform
- Windows
hi, I am working on a project, need to sort the value and create dependent drop down menu.
Here is the example:
For column " Sorted" formula as : =IFERROR(INDEX($AU$41:$AU$50,MATCH(AL41,$AV$41:$AV$50,0)),"")
How can I do it without manually go to the ribbon and sort every time?
Thanks in advance for your help.
Here is the example:
For column " Sorted" formula as : =IFERROR(INDEX($AU$41:$AU$50,MATCH(AL41,$AV$41:$AV$50,0)),"")
How can I do it without manually go to the ribbon and sort every time?
Thanks in advance for your help.