Find max value in range and return corresponding value in offset range

Hi all,

very frustrating simple problem.

I have a table from A5:G10 and another table N5:T10

I need to find the MAX value in table A5:10, which is fine.

But i then need to find the corresponding value in the table N5:T10.

So basically, i'm finding the position of MAX(A5:G10), then finding the value in the same row but offset 13 columns to the right.

It seems so simple and i've tried so many different formulas, but i keep getting #N/A

I tried =OFFSET(A5,MATCH(MAX(A5:G10),A5:G10,0),13) and i just get #N/A. SO FRUSTRATING!

I thought this should work but i have no idea why it isn't.

Can anyone help with any ideas? thanks

Joel

p.s: I'm running Excel 2003