Oopps!
 

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.

Oopps!
 

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

On Aug 28, 9:12 pm, Leonhardtk
wrote:
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.

Oopps!
 

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

"Pete_UK" wrote:

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

On Aug 28, 9:12 pm, Leonhardtk
wrote:
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.

Oopps!
 

=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".



"Leonhardtk" wrote:

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

"Pete_UK" wrote:

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

On Aug 28, 9:12 pm, Leonhardtk
wrote:
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.