Forum Discussion

mesa88's avatar
mesa88
Copper Contributor
Dec 21, 2022
Solved

Search Box Formula

Hi, 

 

Can anyone help me out with this very basic scenario involving a search box.

I have added a snippet but cannot understand why its not filtering when trying to search "Advisor Name".

 

 

any ideas please? sorry, completely new to Excel here.

excel
Formulas and Functions
    • mesa88's avatar
      mesa88
      Copper Contributor
      Dec 21, 2022
      Thanks for responding. Do forgive me if I am missing something here- advisor named "saif" is in the table- the first name on the list.
      I have tried changing the formula around to search for "gradbay" and it seems to work and search that column.
      • Patrick2788's avatar
        Patrick2788
        Silver Contributor
        Dec 21, 2022

        mesa88 

        Try this:

        =FILTER(Gradbay,ISNUMBER(SEARCH(H2,Gradbay[Advisor Name])),"No Record")

Resources