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?