Can you provide a sample of your data and expected results?

Quote Originally Posted by andyp161
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