IF + AND + LOOKUP

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I have a huge database with ranges (between numbers)
Example
a1 = 0 and b1 = 50
a2 = 51 and b2 = 100 etc etc
In column c i have the return value
In column D i have random numbers so the formula will be:
d1 = 62
If d1 is between ?? then return the corresponding cell in c

Help Please!!!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
How about some thing like this

=INDIRECT("C" & IF(ISERROR(MATCH(D1,A:A,0)),MATCH(D1,A:A,1),MATCH(D1,A:A,0)))