|This formula will return the value in the cell that is one row below the maximum value in the specified range.|
It should not be used in A11 because it will fail if A10 contains the maximum value.
MAX will find the maximum value
MATCH will return the position within the range where the maximum value was found. Note: This is not the Excel Row number, but the position within the array.
INDEX will return the Address of the cell at that location
OFFSET will return the value in the cell one Row below that Address.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.