Forum Discussion

DonYTechGuy's avatar
DonYTechGuy
Copper Contributor
Apr 17, 2020
Solved

How would I add to this formula so it will incorporate multiple rows not just A5 ...

=SORT(FILTER(A2:A99,ISNUMBER(SEARCH(Report!A5,A2:A99)),"not found")) Thanks in advance for any and all suggestions. 🙏 Don Y
excel
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 17, 2020

DonYTechGuy I see. You are after a "searchable dropbox". The solutions found on the web work for one cell only. Precisely as you described in your video.

The attached file has a work-around so that works for multiple cells, one after the other and always at the last one in your list. Play around with it and see if you can get it to work. Otherwise, I can have a look at it tomorrow. Its 8:30pm in my part of the world and I have plans for the evening.

  • DonYTechGuy's avatar
    DonYTechGuy
    Copper Contributor
    Apr 18, 2020

    Hi SergeiBaklan and Riny_van_Eekelen , I would like to THANK YOU both for your thoughtful suggestions. Leila's suggestions within this video were EXACTLY what I was looking for!  https://www.youtube.com/watch?v=waqzwMCYD9I,

    Here's the link to her post on the topic ... https://www.xelplus.com/excel-searchable-drop-down-every-row/

    Here's the link to her downloadable MS Excel Spreadsheet to view the formula for yourself ...

    Feel free to Download the Workbook ...

    https://www.xelplus.com/wp-content/uploads/2020/04/Excel_Searchable_Data_Validation_EveryLine.xlsx

    Thank you both again ... Mission Accomplished!

    Don Y 

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 18, 2020

      DonYTechGuy 

      Don, glad to know you sorted this out. That thanks to Leila.

      • DonYTechGuy's avatar
        DonYTechGuy
        Copper Contributor
        Apr 18, 2020

        SergeiBaklan Hi Sergei, Thanks again and was the "Sorted" pun intended? 

Resources