Random table of data - need to find every cell that contains specific data

Here is what I am attempting to accomplish. I have two small tables of randomly generated data.

• each table has a header row and header column (see Grids)
• randomly generated data consists of two letter abbreviations (see Variables)
• I need to pull from random table data every cell that contains a specific two letter abbreviation
• and show the column header and row header (combined in one cell) for each cell that contains the two letter abbreviation

My question is: Is there a way to systematically find every cell that contains specific text and display the column header/row header for each occurrence found within a range of cells? Please see my attached sample for further clarity.