Match, Hlookup or?? to relocate and match up data to sorted data

I'm still playing around with Match and V/Hlookup functions and haven't gotten them fully understood yet, but this should be easy. If I can see it done or see how it works exactly I can normally do it from then on. Not having much luck wit this one though. I have a section that shows data for each month. Jan. thru Dec. I have it sorted from large to small below it. How would I go about taking, say there was 130 in Mar. and that was the largest sorted, then find 130 in the other section and have it find the 130 and Mar. above it from one chart and put the Mar. above the sorted chart? I have a sample to make it easier? If anyone has time to look at it that is. I really would appreciate it.

Sorry,
I should have marked what was what on that. Pretty tired here. Let's try this one.

Originally Posted by AliGW

Ah, I see now! OK - give me a minute.

You are wonderful! Thank you so much!!!

One way

in G3 and copy across (RANK to account for duplicates)

=RANK(G2,$G$2:$R$2)+COUNTIF($G$2:G2,G2)-1

In G5

=INDEX($G$1:$R$1,MATCH(COLUMNS($G:G),$G$3:$R$3,0))

in G6

=INDEX($G$2:$R$2,MATCH(COLUMNS($G:G),$G$3:$R$3,0))

Originally Posted by AliGW

Sorry - got called away. Hopefully someone else will chime in.

It's alright. It got taken care of. Thank you so much for looking at it anyway. It is much appreciated!!!

Originally Posted by JohnTopley

One way

in G3 and copy across (RANK to account for duplicates)

=RANK(G2,$G$2:$R$2)+COUNTIF($G$2:G2,G2)-1

In G5

=INDEX($G$1:$R$1,MATCH(COLUMNS($G:G),$G$3:$R$3,0))

in G6

=INDEX($G$2:$R$2,MATCH(COLUMNS($G:G),$G$3:$R$3,0))

Thank you so, so much!!!!! Worked like a charm and was all I needed to finish my book! You are all amazing!!! Just amazing minds, abilities and people!!!

Originally Posted by FlameRetired

Another way.

Array enter this formula in G5 and fill across. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

Thank you very much for your reply and help also! I have your formula in my list of go to's now also. I wish I knew half as much about Excel as you people! (I wouldn't get much done other than making sheet after sheet though!
Thank you so much again!!!