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?