Trying to figure out how I can match the name across 2 sheets and then search columns B and C for the TG1 skill in sheet 2, then mark the names with a Y in column B of sheet1.
A1 Name / B1 Tech Grade 1
A2 Joe / B2 Box to be filled or not based on result for Joe in sheet2
A3 Dave / B3 Box to be filled or not based on result for Dave in sheet2
A4 Karen / B4 Box to be filled or not based on result for Karen in sheet2
Sheet 2 export from a phone system.
A1 Name / B1 Primary Skill / C1 Secondary Skill
A2 Frank / TG1 / TG2
A3 Dave / TG3 / TG1
A4 Karen/ TG2 / TG3
I have a formula that works as long as B1 in Sheet 1 is named TG1:
But I need to have the label for B1 in Sheet1 expanded to a full name. Is there any way to adjust this formula to not look for a match of the value B1 in Sheet 1 and only search for a text string or partial text string?