OFFSET AND Address of Minimum Value does not work

[dwg83]

1 2 3 4

45 55 30 60

Here is my issue, I want to find the minimum value of the second line, but return the value located two rows above it....so 3

I thought this formula was going to work but no such luck

=OFFSET(CELL("address",INDEX(C1:C4,MATCH(MIN(C1:C4),C1:C4,0))),-2,0)

Help, Thanks!

 

[VoG]

Try

=INDEX(A1:D1,MATCH(MIN(A3:D3),A3:D3,0))

 

[dwg83]

Thanks worked well

 

[jasonb75]

For reference, CELL("Address",???) returns the address as a text string, so you would need to use INDIRECT(CELL("Address",???)) to return a valid range. The same applies to the ADDRESS(row,column) function, and possibly others that don't spring to mind.

As peter's suggestion shows, there is (usually) a way to achieve the same result without the need to nest several functions.