Oopps!

[Guest]

I apologize. I have two mistakes in this my earlier question:

The problem is I can't ever get the "value if FALSE". The formulate treats
everything after the first lookup as "value if TRUE".

ALso, in the first Look up I have {1,4,15,"over 30"}, but that should have
been {1,7,14,30} (Again I apologize, but my spreadsheet is on another
network with no Internet access, so I have write down the formula and retype
in this window (which may also mean my paranthesis may not be correct
either!?"

KSL.

 

[Pete_UK]

So, are you asking a question now? I haven't seen your earlier posting
(yet - I read them in the order of most recent first when I log on),
so I haven't a clue what you are talking about. It probably would have
been better to have added this as a reply to your first posting,
rather than start a new one with little detail in it.

Pete

 

[Guest]

My mistake. I was in my original posting, and thought my "new" question
would be nested under my original question. My original question had the
subject "LOOKUP" within a condition?"

Thanks,

KSL

 

[Guest]

=IF(V2="Incident",
LOOKUP(TODAY()-INT(AK2),{1,4,14,30},{"0-7","8-13","15-29","Over
30"}),LOOKUP(TODAY()-INT(AK2),
{1,30,60,90,120},{"0-29","30-59","60-89","90-119","Over 120"}))

works fine for me.

With AK2=01/08/07 (1st August) and V2="Incident", I get result of "15-29";
if V2 is blank, I get result of "0-29".