Vlookups or iferror?

[ExcellingAZ]

What I am looking to do is identify skills not found in agent profiles. Profiles Names are found in Column A , Dept column B and Agent Skills in Columns C. The "Lookup Directory" is listed in Dept Column E and Skill Master Column F. I would like the results to appear in column J. So example, CHTHY master list columns E/F show that AGENT_PG_.031BCT and AGENT_PG_01.259.SMB_OF should be appearing in columns C for each guide but is missing for Mickey_Mouse and Mouse_Minnie . The skills AGENT_PG_.472_EmSls_V3_C1_OF2 and AGENT_PG_.475_Sales_V3_C1_ or missing from Duck_Donald and McDuck_Scrugg. I would like these skills that are missing to populate in column J. Is this doable?

 

[Saurabhj]

Hi, can you please share the expected output in column J.

Would you like to search for any specific Agent or want to show agent name and corresponding missing skills.

 

[ExcellingAZ]

I would like the agent name and corresponding missing skill.