IF statement: if A2="one of these 5 words", then YES, otherwise NO

[marlowg]

I'm trying to create a column saying whether staff are "Trained" or "Untrained".
Without being old school and doing find and replace!

Say for arguments sake there are 5 different "trained" grades.

I want the IF statement to say

=(IF

The value in A2 is any of these:
NQA1
NQA2
NQA3
etc (not all starting NQA btw!)

then value in new column is TRAINED

If anything else - UNTRAINED



I know how to do this when it's either a value, or it's not - but how do I do it to check it against a list of values?
I've had a search but maybe I'm not looking for right words.


Thanks,

[ragulduy]

=IF(ISNUMBER(MATCH(A2,{"NQA1","NQA2","NQA3"},0)),"Trained","Untrained")

[Fotis1991]

One way.

Please Login or Register  to view this content.

[martindwilson]

=IF(OR(A2={"NQA1","NQA2","NQA3"}),"trained","untrained ")
or slightly longer
=IF(ISNUMBER(MATCH(A2,{"NQA1","NQA2","NQA3"},0)),"trained","untrained ")

[Olly]

Try:

Please Login or Register  to view this content.

[Fotis1991]

Thanks for the rep. So

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.