4.ods (27.9 KB)
How can i get the nearest smaller number from the left?
Ex: for the 999, the number i’m looking for is 975, not 1000.
Or using xlookup
4_134584EA.ods (22.3 KB)
[Edit]
You can extend the conditional formatting to include E by editing the conditional range to B2:B30;E2:E6
If you change the sort order, a most simple LOOKUP will do the job.
emyxample4_Re2.ods (28.3 KB)
1 Like
I prefer solutions which not depend on conditions which may be disregarded on day
emyxample4_ReLuppB.ods (25.1 KB)
.
… maybe
=VLOOKUP(D9;SORT(B$2:B$30;1);1)
The solutions is so easy, i was looking into functions like this:
=INDEX(P10:P620;MATCH(MIN(ABS(P10:P620-100));ABS(P10:P620-100);0))
Thank you.
@ Villeroy:
We shouldn’t mix up "smaller (< / LT) with (<= / NG).