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,