Unfortunately I can't seem to post attachments here so here's what data I have:
On tab [Amount]
On tab [source]Please Login or Register to view this content.
Please Login or Register to view this content.
Based on what I fill in in column Amount.1, my formula does a lookup in column source.A, and finds the corresponding value in source.B and shows that in column Amount.2
This formula works:
However, it finds the closest value in source.A, even if that value is HIGHER than the value I enter in Amount.1Please Login or Register to view this content.
So for example, when I enter "111.20" in Amount.1, it now shows "41.67", but the value I want is the value that corresponds to either exactly 111.20 OR the nearest lower value. In this case 111.20 does not exist, so it should take the value 108 and thus return corresponding value "40.00"
Bookmarks