Finding Value based on Max Value

[causticelephant]

Hey,

I have been creating an excel sheet and need to add a formula which finds the cell 3 cells to the left of whatever the MAX value is across a set of values all in the same row but not next to each other (roughly 100 values in all). Is this at all possible? If so, how?

Thanks a lot for any help in advance.

 

[mikerickson]

Something like =INDEX(1:1, 1, MATCH(MAX(1:1), 1:1, 0) -3)