Rank, Match, Index

[milikien]

Hi, I am hoping someone can help me with a RANK and MATCH question. I have successfully isolated the largest number from a range of several sheets, but matching the corresponding date is where I have trouble. I have 13 tabs, one for each month and a ranking tab. I am able to pull the first, second, third… value from the ranges using:
=LARGE(Jan:Dec!C$3:C$12,1)
Now matching the date is where I have an issue. I’ve tried:
=INDEX(Jan:Dec!A3:A12,MATCH(G4,Jan:Dec!C3:C12,0),1)
=VLOOKUP(G5,Jan:Dec!A3:C12,1,FALSE)
=OFFSET(G6,MATCH(G6,Jan:Dec!C3:C12,0),-1)
The MATCH and INDEX works on the same sheet, but I don’t think MATCH will work across several tabs. Does anyone have a suggestion? Thanks

 

[Domenic]

I'd suggest that you use a separate worksheet to consolidate your data. Then a formula solution would be fairly straight forward.