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