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

=INDEX(HW20:II20,MATCH(MAX(HW28:II28),HW28:II28,0))

<tbody>
</tbody>

 

[NewOrderFac33]

That's perfect - thank you VERY much!

 

[DanteAmor]

I'm glad to help you!