Hi there,

I am using the LARGE, INDEX and MATCH functions to show the largest averages and related 'row' information from another table. However, the way my source table is set out, I now want to pull information associated with the largest average (the total) which is entered in the cell above the average i.e the same column rather than row. Is this possible?

Many thanks