Returning the Row/area based on search results

[MQuakkelaar]

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?

[#2]

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.

[#3]

(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.

[#4]

@MQuakkelaar Does this work for you? (I told you it was complicated!)

[#5]

@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.

[#6]

@MQuakkelaar This is a simpler formula for getting the hits:

=FILTER('Data (Do Not Change)'!B:B,'Data (Do Not Change)'!A:A=Y3)