I had this sorted yesterday, but too much clicking of the Undo and lost it.
I have two numbers in cells F5 and F6 and need to match the higher value to a list, displaying either the match or if not matched, the next value in sequence.
<tbody>
</tbody>
In this case, searching for the result of max(F5:F6) should return a value of 0.50 from range F8:J8.
<tbody>
</tbody>
But in this case, searching for the result of max(F5:F6) should return the value of 1.00 from range F8:J8.
Should the result of max(F5:F6) be greater than J8, I need to trap it as an error.
Yesterdays solution was so simple.
Many thanks.
I have two numbers in cells F5 and F6 and need to match the higher value to a list, displaying either the match or if not matched, the next value in sequence.
F | G | H | I | J | |
5 | 0.375 | ||||
6 | 0.5 | ||||
7 | |||||
8 | 0.25 | 0.50 | 1.00 | 2.00 | 3.00 |
<tbody>
</tbody>
In this case, searching for the result of max(F5:F6) should return a value of 0.50 from range F8:J8.
F | G | H | I | J | |
5 | 0.625 | ||||
6 | 0.50 | ||||
7 | |||||
8 | 0.25 | 0.50 | 1.00 | 2.00 | 3.00 |
<tbody>
</tbody>
But in this case, searching for the result of max(F5:F6) should return the value of 1.00 from range F8:J8.
Should the result of max(F5:F6) be greater than J8, I need to trap it as an error.
Yesterdays solution was so simple.
Many thanks.
Last edited: