Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Range | Excel Worksheet Functions | |||
vlookup more than 2 range | Excel Discussion (Misc queries) | |||
vlookup for more than 2 range | Excel Discussion (Misc queries) | |||
VLookup Range Help | Excel Worksheet Functions | |||
Vlookup for range, help | Excel Worksheet Functions |