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.