The most popular meals in Italy

I'm trying to build out a list of the top cells in a cross-tab. I'm trying to create a top ten list of pasta and wine in all of Italy. I have a table of # meals served by type of pasta and wine. How can I go about creating a table of the most popular combinations?

I've figured out how to extract the top values using the LARGE() function, but how to secure the corresponding column and row labels so that I can have a nice chart?

RANK PASTA WINE MEALS SERVED
1 Ravioli Sangiovese 9982
2...
3...

Full disclosure, the data is fictional, but typing it up made me hungry nonetheless.
Screen Shot 2021-07-02 at 7.29.27 PM.png

C6=INDEX(F:F,SUMPRODUCT(($G$4:$R$24=LARGE($G$4:$R$24,ROW(A1)))*(ROW($G$4:$R$24))))
D6=INDEX($3:$3,SUMPRODUCT(($G$4:$R$24=LARGE($G$4:$R$24,ROW(A1)))*(COLUMN($G$4:$R$24))))

Formula above will give you result directly from table area without helper column in B.

It looks like you use the A1 to derive the rank. Very smooth. Thank you. I dropped it in and it worked like a charm.

For reference if anyone decides to actually use the excel I uploaded, there is an error in the meals served column. B6 should say =LARGE($F$4:$R$24,A6)

Alternate formulas,
C6=INDEX($G$4:$G$24,SUMPRODUCT(($H$4:$S$24=$B6)*ROW($G$4:$G$24))-ROW($G$4)+1)
D6=INDEX($H$3:$S$3,SUMPRODUCT(($H$4:$S$24=$B6)*COLUMN($H$3:$S$3))-COLUMN($H$3)+1)

Cell C6 array formula , Drag down

HTML Code: 

Cell D6 array formula , Drag down

HTML Code: 

Originally Posted by josephteh

Alternate formulas,
C6=INDEX($G$4:$G$24,SUMPRODUCT(($H$4:$S$24=$B6)*ROW($G$4:$G$24))-ROW($G$4)+1)
D6=INDEX($H$3:$S$3,SUMPRODUCT(($H$4:$S$24=$B6)*COLUMN($H$3:$S$3))-COLUMN($H$3)+1)

Sorry, correction:
C6=INDEX($F$4:$F$24,SUMPRODUCT(($G$4:$R$24=$B6)*ROW($F$4:$F$24))-ROW($F$4)+1)
D6=INDEX($G$3:$R$3,SUMPRODUCT(($G$4:$R$24=$B6)*COLUMN($G$3:$R$3))-COLUMN($G$3)+1)