Excel - Lookup Formula Query

[Uzzgee]

Hi,

Hope everyone is well.

Looking for some more help - hopefully a simple ( but too difficult for me) formula to conduct the following...

I have used coloured cells in the JPEG to explain.

I need to find the MAX value in a single row ( Yellow cells) and fill out the answer cell (Green Cells) the with corresponding column value (Red Cells).

I have over 9000 rows to calculate and i need to do it on several columns, Max, Min, average etc....

As always thanks in advance.

Regards

Uzz

[Kaper]

use INDEX MATCH and MIN/MAX functions.

something like in j2:

Please Login or Register  to view this content.

[Uzzgee]

Perfect Kaper - many thanks for your assistance.