How can I find a # in a range & return the row/column titles associated with that #?

I'm trying to figure out how to do the above, and attached an Excel example. I'm trying to write a formula (likely 2 formulas) that will return the right data in cells D13, E13, D14, E14, etc. (currently hard-coded in red and highlighted in yellow in the attachment). I thought it could be some sort of INDEX/MATCH combo, or possibly OFFSET/MATCH, but can't seem to figure it out.

Basically, I have a range -- call it A1:G9. I have category titles in Row 1 and Column A. Lots of random numbers in the data range (B2:G9), all between -1 and 1 (e.g. 0.0657). I'm trying to find the 1st, 2nd, 3rd, (etc.) largest numbers in the range -- easy, with the LARGE function.

So, let's say the 1st largest number is 0.473195 (located in F9), and the 2nd largest number is 0.450069 (located in E5). How do I write a formula to tell me what's the category titles are for each of these results. For example, for the 1st largest number (happens to be in F9), I'd want a formula to return F1 ("FF") and another formula to return A9 ("99"). And for the 2nd largest number (happens to be in E5), I want a formula to return E1 ("EE") and another formula to return A5 ("55"). And so on.

I'm assuming there's a way to write a dynamic formula to do this -- simply finds the exact value that I've specified, and tells me what the category (row/column) titles are. Doubt I would need to copy the row/column titles to an outer row/column so that it would work with VLOOKUP/HLOOKUP, but I'm open to that if necessary.

Any thoughts on how to do this? Thanks for your help!

Take a look at the attached.

In my example, The table (including headers) is in A1:G10.

In I2 is
=LARGE($B$2:$G$10,ROW(A1)) dragged down
In J2 for Column is Arrayed formula
=INDEX($B$1:$G$1,MIN(IF($B$2:$G$10=$I2,COLUMN($B$2:$G$2)-COLUMN($B$2)+1)))

In K2 for Row is arrayed formula
=INDEX($A$2:$A$10,MIN(IF($B$2:$G$10=$I2,ROW($A$2:$A$10)-ROW($A$2)+1)))

To create an Arrayed formula, while still in the formula bar, use CNTRL SHFT ENTER instead of a simple enter. You'll see {} around your formula if done properly.
Does this work for you?

First question, did you use CNTRL SHIFT ENTER to create those formulas such that you see the brackets around them?

If you did that and it's still not working, show me the formula's you used and I should be able to figure out what is wrong with them. I've attached a rework of your original file that you posted. Maybe that will help.

The final A5 should be anchored (same with your other formula for COLUMN)

=INDEX(Correlations!$A$4:$A$61,MIN(IF(Correlations!$B$4:$BG$61=$C6,ROW(Correlations!$A$4:$A$61)-ROW(Correlations!$A$5)+1)))
Does that fix anything?

I was more knowledgeable ab out Excel years ago

LOL, I'm that way about a lot of things!