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 highlight the inventory number if it is in stock.
I am wanting to have the Row and area (A,B,C,D, or E) returned below the search box, is that possible? If so how should I go about it?
- 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!)
