SOLVED

Highlighted
New Contributor

# IF/THEN help

Hi - I think I need an if/then formula, but I am not 100% positive.

I am creating a spreadsheet to track trainer certifications and availability.

I need to determine if the course (column B) is one listed in their certifications (column E).  If it is, "yes" would go in column F, if it isn't, "no" would go in column F.

Once I determine how to identify if they are qualified, I will need to determine if they are available or currently booked.

 DATE COURSE LOCATION INSTRUCTOR CERT QUALIFIED? 05/08/19 1 Pittsburgh 1 1, 2, 3, 4 04/21/19 1 Pittsburgh 1 1, 2, 3, 4 05/22/19 4 Pittsburgh 2 1, 2 03/01/19 1 Pittsburgh 3 1, 2, 3 04/05/19 3 Pittsburgh 3 1, 2, 3 03/08/19 2 Pittsburgh 3 1, 2, 3 06/24/19 2 Pittsburgh 3 1, 2, 3 05/07/19 1 Virginia 5 1, 2, 3, 4 05/01/19 4 Virginia 5 1, 2, 3, 4 05/04/19 1 Virginia 6 1 03/15/19 3 Virginia 9 1, 2, 3 04/21/19 2 Maryland 10 1, 2, 3, 4

3 Replies
Highlighted
Best Response confirmed by CParker (New Contributor)
Solution

# Re: IF/THEN help

Assuming the certifications are not more than 9, you can use this formula starting in F2:
=IF(ISNUMBER(FIND(B2,E2)),
“Yes”,
“No”)
Highlighted

# Re: IF/THEN help

Thank you very much!  That did exactly what I needed it to do. :)

Highlighted

# Re: IF/THEN help

You’re very much welcome!