vlookup/index/match???

[Georgia Golfer]

The sample attached is a micro version of what I am working on.

I have 38 customers that I want to rank in column form based on a tab that has ranked them in row form. Sheet B is a formula tab that compiles data from a branch tab and ranks across all branches, in this case, 1-10.

I want Sheet 1 to look up the #1 ranked customer & give me the customer name. I can adjust the formula from there to find the totals.....I just have a hard time with combining formula's....

Thanks a lot,
Jeff

[mrice]

Please see the attached which uses the HLOOKUP function. I needed to move the rank row on the second sheet to make this work.

[martindwilson]

you might want to consider unique rank in case you have the same values in b4:k4 or hlookup wont work
properly
instead of =RANK(B4,$B$4:$K$4) in b2 use
=COUNT($B$4:$K$4)-(RANK(B4,$B$4:$K$4)+COUNTIF($B$4:B4,B4)-1)+1