Lookup function with multiple criteria

I have a formula that I am using to draw a status from another table if it does not meet a specific criteria. Basically, look in the column to see if there is data, if there is then ignore it if that data reads "initial reject." If it doesn't read "initial reject" then return the value which would typically be "approved, rejected of in work." Now though there's been another criteria added that will need to be filtered out just like the initial reject which is "prev rev."

Here is my current formula:

Please Login or Register  to view this content.

Originally Posted by Craig K.

Tony, I tried but my browser decided to mess with me regarding the 10 character min that the edit requires. Either way, I messed up and won't delete it now. It will forever be a mark of shame against my internet permanent record .

Rajn - Tony was basically pointing out that my initial post won't work because the OR() function returns the binary value of True/False and will result in an error where I put it. This one has more thought put into it and I think it will work:

Formula:

Please Login or Register  to view this content.

I tried it and for some reason it is still returning the "PREV REV" & now also the "INITIAL REJECT." That's the same result I was getting before when I tried to modify it myself.

As it seems, even if I click to edit the formula, but don't actually change it the cell starts picking up the "INITIAL REJECT" instead of the "APPROVED"

It's been a while since I created this thing, so maybe I'm doing something incorrectly. Enter the new formula, then CTRL ENTER, correct?

Originally Posted by Craig K.

If you're making it an array formula, leave off the initial {} brackets and then do ctrl+shift+enter

It still seems to be ignoring the IF segment and returning those results anyway. I'm going to try to break this down this evening and see what it's giving me now. I may just have to go at it from the opposite direction and have it look for the desired returns (APPROVED, REJECTED & IN WORK)