M
Mel
I thought the HLOOKUP would be sufficient. Not the case.
I have 4 dollar amounts in Row 1 (A11) and a dollar amount in E1. E1 is
the main value that must be compared to A11 and the result is to return a
value found in A11 closest BUT not exceeding E1.
Any suggestions or thoughts would be GREAT! Thank you.
I have 4 dollar amounts in Row 1 (A11) and a dollar amount in E1. E1 is
the main value that must be compared to A11 and the result is to return a
value found in A11 closest BUT not exceeding E1.
Any suggestions or thoughts would be GREAT! Thank you.