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?

​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?  Read More

​