×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

IIF command in MS Project

IIF command in MS Project

IIF command in MS Project

(OP)
Hi, I wonder if someone could help me. I apologise in advance for the garbled explanation. I would like to create an IIF formula thst could help achieve what I've described below.

I have several columns in my plan and need to create a new column that would contain values already existent in some other columns.

1st column contains a value, let's call that AB, could be BC, CD or several other options (at least 10 to 15 of then)

2nd column also contains values, let's call this EF, FG, GH. Again this has about 10 to 15 variants.

I then want my new column to be populated with a value from a list of about 10 to 15 options in a lookup table.

To be clear, it's not just a simple concatenation. I need to list all the possible variants and want the new column auto filled with the correct option from the lookup table.
I'm hoping I can get some help with using the IF formula (I'm not good with these at all) to create statements such as "IF 1st column = AB (I'd need to know how to point it to the right columns) and 2nd column = CD then select WXYZ from lookup table in new column.

Hope this is a bit clear. Thank you.

RE: IIF command in MS Project

Hi,

I'd code a function in Project VBA. But seems you may have an aversion to VBA.

I do not believe that it is possible to nest 8 or more IIF() functions.

Apparently the SWITCH() function is available. Let me take a try. I'll start with a abridged form, which you ought to be able to expand. I tested a version of this in Excel VBA with success...

ROW2: =SWITCH((A2="AB" AND B2="CD"),"RESULT1",(A2="AC" AND B2="DC"),"RESULT2")


General syntax...

=Switch(expr-1, value-1, [ expr-2, value-2…, [ expr-n, value-n ]])

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: IIF command in MS Project

(OP)
Skip, my aversion to vba is borne of lack of ability 😁. I just can't seem to get it.

RE: IIF command in MS Project

(OP)
Thanks, I'll try this out this morning.

RE: IIF command in MS Project

(OP)
Skip, you're simply fab. That worked, thank you ever so much. I'm so appreciative 👍🏽

RE: IIF command in MS Project

Well it was a stab-in-the-dark. I assumed that the VBA syntax would mirror the Project formula syntax. Glad you have a workable solution.

Would you please post your completed solution for the edification of other Tek-Tip members?

Likewise, would you also post your completed solution in thread68-1795385: Microsoft Project IF formula, help needed please, where you originally posted.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: IIF command in MS Project

(OP)
Sure, I'll do that once I finish and document the solution. Thanks again.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close