Mar 04 2019 05:12 AM
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 |
Mar 04 2019 06:20 AM
SolutionMar 04 2019 06:25 AM
Thank you very much! That did exactly what I needed it to do. :)
Mar 04 2019 06:20 AM
Solution