SOLVED
Home

IF/THEN help

%3CLINGO-SUB%20id%3D%22lingo-sub-359748%22%20slang%3D%22en-US%22%3EIF%2FTHEN%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359748%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20I%20think%20I%20need%20an%20if%2Fthen%20formula%2C%20but%20I%20am%20not%20100%25%20positive.%3C%2FP%3E%3CP%3EI%20am%20creating%20a%20spreadsheet%20to%20track%20trainer%20certifications%20and%20availability.%20%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20determine%20if%20the%20course%20(column%20B)%20is%20one%20listed%20in%20their%20certifications%20(column%20E).%26nbsp%3B%20If%20it%20is%2C%20%22yes%22%20would%20go%20in%20column%20F%2C%20if%20it%20isn't%2C%20%22no%22%20would%20go%20in%20column%20F.%3C%2FP%3E%3CP%3EOnce%20I%20determine%20how%20to%20identify%20if%20they%20are%20qualified%2C%20I%20will%20need%20to%20determine%20if%20they%20are%20available%20or%20currently%20booked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EDATE%3C%2FTD%3E%3CTD%3ECOURSE%3C%2FTD%3E%3CTD%3ELOCATION%3C%2FTD%3E%3CTD%3EINSTRUCTOR%3C%2FTD%3E%3CTD%3ECERT%3C%2FTD%3E%3CTD%3EQUALIFIED%3F%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E05%2F08%2F19%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EPittsburgh%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E1%2C%202%2C%203%2C%204%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E04%2F21%2F19%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EPittsburgh%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E1%2C%202%2C%203%2C%204%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CSTRONG%3E05%2F22%2F19%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E4%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3EPittsburgh%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E2%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E1%2C%202%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E03%2F01%2F19%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EPittsburgh%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E1%2C%202%2C%203%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E04%2F05%2F19%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3EPittsburgh%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E1%2C%202%2C%203%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E03%2F08%2F19%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EPittsburgh%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E1%2C%202%2C%203%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E06%2F24%2F19%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EPittsburgh%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E1%2C%202%2C%203%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E05%2F07%2F19%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EVirginia%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E1%2C%202%2C%203%2C%204%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E05%2F01%2F19%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3EVirginia%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E1%2C%202%2C%203%2C%204%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E05%2F04%2F19%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EVirginia%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E03%2F15%2F19%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3EVirginia%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E1%2C%202%2C%203%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E04%2F21%2F19%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EMaryland%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E1%2C%202%2C%203%2C%204%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-359748%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359789%22%20slang%3D%22en-US%22%3ERe%3A%20IF%2FTHEN%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359789%22%20slang%3D%22en-US%22%3EYou%E2%80%99re%20very%20much%20welcome!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359788%22%20slang%3D%22en-US%22%3ERe%3A%20IF%2FTHEN%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359788%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20very%20much!%26nbsp%3B%20That%20did%20exactly%20what%20I%20needed%20it%20to%20do.%20%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359784%22%20slang%3D%22en-US%22%3ERe%3A%20IF%2FTHEN%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359784%22%20slang%3D%22en-US%22%3EAssuming%20the%20certifications%20are%20not%20more%20than%209%2C%20you%20can%20use%20this%20formula%20starting%20in%20F2%3A%3CBR%20%2F%3E%3DIF(ISNUMBER(FIND(B2%2CE2))%2C%3CBR%20%2F%3E%E2%80%9CYes%E2%80%9D%2C%3CBR%20%2F%3E%E2%80%9CNo%E2%80%9D)%3C%2FLINGO-BODY%3E
CParker
New Contributor

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.

 

DATECOURSELOCATIONINSTRUCTORCERTQUALIFIED?
05/08/191Pittsburgh11, 2, 3, 4 
04/21/191Pittsburgh11, 2, 3, 4 
05/22/194Pittsburgh21, 2 
03/01/191Pittsburgh31, 2, 3  
04/05/193Pittsburgh31, 2, 3  
03/08/192Pittsburgh31, 2, 3  
06/24/192Pittsburgh31, 2, 3  
05/07/191Virginia51, 2, 3, 4 
05/01/194Virginia51, 2, 3, 4 
05/04/191Virginia61 
03/15/193Virginia91, 2, 3  
04/21/192Maryland101, 2, 3, 4 

 

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

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

You’re very much welcome!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies