HiAll,
I am trying to create a searchable drop down list in excel, I have done this however, i need the same search in more cells to creat a recipe builder but I cant seem to manage it. Any help would be appreciated.
Please see attached example.
A1 Search onions finds onions
A2 search coca cola only find onions
A3 same as A2
Last edited by Mitchell1970; 07-21-2021 at 05:42 AM.
All sorted thank you,
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, please share your solution for the benefit of all members. Thanks.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
OK, IN the box where I had the original search drop down, I typed
=cell("contents")
this then let me use the same formula in the next cell down.
How can you make it so that the searchable drop down list in cell B10 "resets" and you see the full list of options? Currently you are only able to select from the list what is in cell B9 because the B9 selection is filtering the list in the MASTER DATA tab.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks