Large Index Match Problem

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

Please can anyone help on the above?? - I'm totally stuck!!

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

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