I have two Drop Down Menus and I want to make the second show values based on what I picked in the first one.
I used IF function in data validation but it doesn't work.
Here is the example: Capture d'?cran 2024-05-20 152036.png
I have two named ranges country and city.
I have used this formula in city drop down to show the first us cities if I selected us, if not show all, but it doesn't work :
=IF($E$3=$A$2,INDEX(city,2,1),city))
Are you still using Excel 2019?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
No I use office 2021
Please update your forum profile ASAP.
Done Thanks
Please attach a sample workbook.
Scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks