Forum Discussion
Returning the Row/area based on search results
I am developing a spreadsheet to keep track of inventory at my work based on specific locations. I have all of the data here: I also have a search function built with conditional formatting to...
MQuakkelaar Does this work for you? (I told you it was complicated!)
JKPieterse this is what I ended up going with. (haha, yes it was complicated!) I added all the cells to the data tab and then used that to return the Row/area based on the search. This also allowed multiple values to be shown.
MQuakkelaar This is a simpler formula for getting the hits:
=FILTER('Data (Do Not Change)'!B:B,'Data (Do Not Change)'!A:A=Y3)