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...
Anything is possible, but the layout of your data makes it unnecessarily complicated. Can you upload the Excel file you used for the picture? That would be more helpful.
- (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.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.
