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!!!

IF + AND + LOOKUP
Https //accounts.google.com/sign in/v1/lookup - Guide
Area code lookup - Guide
Android ip address lookup - Guide
T mobile sim card lookup - Guide
India license plate lookup - Guide

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)))

Similar discussions

Find my Gmail account

Lookup table? Excel

keyboard shortcut for Smart Lookup

Tiktok search and posting feature not working.

Lookup problem.

Similar discussions

Subscribe To Our Newsletter!