VLOOKUP Range

  • Thread starter Thread starter apb000
  • Start date Start date
A

apb000

Is there a way to have excel look up data that falls BETWEEN two numbers,
i.e. in a range, and return a specified character string? For example, "If
(value) is between B12 and B13, return "Tuesday"". I could always do it with
IF THEN statements, of course, but I'd have to make A LOT of them, and they'd
be huge, elaborate statements. Can't I just do it from a table of values?
 
Hi,

Create a lookup table, in say range D1:E3, such as:
0 Mon
10 Tue
30 Wed

in cell A1 enter a value like 20, in A2 enter the formula
=VLOOKUP(A1,D1:E3,2,1)

The lookup table must be sorted in Ascending order on the first column
because we are doing an approximate match. You can shorten the above formula
to
=VLOOKUP(A1,D1:E3,2)
 
Back
Top