Forum Discussion
MQuakkelaar
Jul 26, 2024Copper Contributor
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...
JKPieterse
Jul 29, 2024Silver Contributor
MQuakkelaar Does this work for you? (I told you it was complicated!)
MQuakkelaar
Jul 29, 2024Copper Contributor
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.
- JKPieterseJul 30, 2024Silver Contributor
MQuakkelaar This is a simpler formula for getting the hits:
=FILTER('Data (Do Not Change)'!B:B,'Data (Do Not Change)'!A:A=Y3)