VLOOKUP Range
 

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?

VLOOKUP Range
 

You can create a table, put the numbers in ascending order and use VLOOKUP

see help for further explanation

http://www.contextures.com/xlFunctions02.html






--


Regards,


Peo Sjoblom



"apb000" wrote in message
...
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?

VLOOKUP Range
 

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)

--
Thanks,
Shane Devenshire


"apb000" wrote:

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?