Explanation
This formula relies on theFILTER functionto retrieve data based on a logical test.
Thearrayargument is provided as B5:D14, which contains the full set of data without headers.
Because this range includes 10 cells, 10 results are returned.
Only rows where the result is TRUE make it into the final output.
Theif_emptyargument is set to “No results” in case no matching data is found.
Wildcards
The SEARCH function supportswildcards, so the filter logic can include these characters.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
SEARCH returns the position offind_textinsidewithin_textas a number.
