Brilliant, thanks Bob.
Not just my syntax, but completely the wrong function!

Regards

Trevor

"Bob Phillips" wrote:

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Trevor Williams" wrote in
message ...
Hi All

I'm trying to return a value using the OFFSET funtion based on the LARGEst
number found in the Offset reference...

something like

=OFFSET(LARGE(B1:B3,1),0,-1)

should return "Item 3" as it has the largest value

A B
1 Item 1 6
2 Item 2 2
3 Item 3 9

Is there a way to do it? Have I just got my syntax wrong?

Thanks

Trevor Williams