Previous Topic Next Topic

IF + AND + LOOKUP

Closed
LOLA - Apr 7, 2010 at 06:12 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 7, 2010 at 06:29 AM
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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 7, 2010 at 06:29 AM
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)))
0

Similar discussions

Find my Gmail account
Dabang -
HelpiOS -

1 response
Lookup table? Excel
jplp123 -
rizvisa1 -

1 response
keyboard shortcut for Smart Lookup
informatiquetique123 -
informatiquetique123 -

4 responses
Tiktok search and posting feature not working.
LpsPride -
HelpiOS -

2 responses