Offset Formula Query

[NewOrderFac33]

Good afternoon!
I'm using the following formula to determine the address of the cell containing the highest value in a range

=CELL("address",INDEX(HW28:II28,MATCH(MAX(HW28:II28),HW28:II28,0)))

but I now want to return the value from the corresponding column in Row 20,
So, if the highest value is found in HZ28, I need the formula to return the value in HZ20, and so on.
Can anyone help out, please?
Thanks in advance
Pete

 

[DanteAmor]

Check with this formula

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]=INDEX(HW20:II20,MATCH(MAX(HW28:II28),HW28:II28,0))[/TD]
[/TR]
</tbody>[/TABLE]

 

[NewOrderFac33]

That's perfect - thank you VERY much!

 

[DanteAmor]

I'm glad to help you!