I was wondering the possibility of an answer to the question in my title.

The formula I have is:

=LOOKUP(A1, E1:E3, F1:F3)


A1 can be any value from say 0 to 1000.

E1:E3 contain different ranges.

 E1 = 0-50
 E2 = 51-800
 E3 = 801-1000

F1:F3 contains a description for each of those ranges.

What is the best way to lookup the value and assign a description? Would I have to have a data list with 1000 entries? Or can Google sheets recognize 0-50 as a range of numbers from 0 to 50?

(I don't want to do an if statement to accomplish this.)


As long as you construct your lookup table as shown (the bounds of the ranges, rather than pairs of limits, and in order) you can rely of the lack of the fourth parameter in a VLOOKUP to select either an exact match or, when no exact match, the match for the next lower value:

WA110146 example

  • 1
    The same would also be done by LOOKUP. – TheMaster Sep 25 '17 at 4:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.