I would be more Thankful if you Provide a solution for the Issue which is taking a longer time to do Manually.
Based on Column A the column B is sheet 2 to be matched against sheet 1 Column B
Sheet2 Column A should Match with Sheet 1 of Column A - Exact Match
Sheet 2 Column B should match aganist column B and C in Sheet 1 - partial Match
Sheet 2 Column B and C has multiple variations of Keywords with comma separated
Match with Plural words for the each Keyword: for Example as for business it should match “Es”
If None of the Keywords matched it should display as Not found
Match should not be case sensitive
All the matched pairs should be populated in Column C and Column D of sheet 1 with comma delimiter
All the adjacent rows From Column D to L of sheet 2 be populated to sheet 1 with comma separated (Only Populate Unique Words with comma delimiter)
While comparing column B key words it should consider exact space match " Co mplete" or "Com plete"
I need to compare 100k rows in sheet1 with almost 400 pairs of keywords of sheet 2
Please find the attached excel