Search field - blank cell

Copper Contributor

Im working on a project for work to keep inventory of the various inks we have. My issue is with the search filter. I can filter my search and generate the request, however when I leave the search field blank, it shows the entire range I'm searching from. I am trying to have nothing generate/show when there isn't anything being searched. 

When I type in 73 red into the search field, it will filter to only show that. If I type in red, it will show me all of the red inks. However when its blank, the entire ink list will populate under the search. Im pretty new to excel and have 

1 Reply

@ChrisAntico 

Change the formula to

 

=FILTER(C4:E169,(K4<>"")*ISNUMBER(SEARCH(K4,C4:C169)),("No Results"))