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...
(I just uploaded the most updated file)
The layout of the data is certainly making it difficult to work with, however, I want to keep this format to use as a map of the warehouse. I plan to somehow link the cells on the "Locations Map" tab to the "Data" tab but have it formatted in a more usable way there to enable the search function to return the location when searching for a part.
The layout of the data is certainly making it difficult to work with, however, I want to keep this format to use as a map of the warehouse. I plan to somehow link the cells on the "Locations Map" tab to the "Data" tab but have it formatted in a more usable way there to enable the search function to return the location when searching for a part.
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)
