Excel Help!

[teknokid]

I'm having a bit of trouble with excel and would appreciate any help that can be offered.

Basically, I've got a massive database of numbers. Then at the top I need to pick out key data. One piece of key data is the maximum of J17:J417.

I then need the matching value from the G column to be reported. So basically, say J48 is the max, I need a cell that can look up G48?

How would I go about writing that? I can't use lookup as the data isn't sorted...

Thanks,

Tom

 

[Grrrrr]

Try this:

=INDEX(G17:G417,MATCH(MAX(J17:J417),J17:J417,0))

If there is one than one instance of the maximum value in column J then it will return the first match.

 

[teknokid]

Try this:

=INDEX(G17:G417,MATCH(MAX(J17:J417),J17:J417,0))

If there is one than one instance of the maximum value in column J then it will return the first match.

Worked an absolute treat, thank you!