Hi Guys:
Need your help.
Sheet1
[TABLE="class: cms_table_grid, width: 500"]
Customer's Name
[/td][td]No of Engagement
[/td][/tr][tr][td]Joe
[/td][td]1
[/td][/tr][tr][td]Charles
[/td][td]2
[/td][/tr][tr][td]Henry
[/td][td]1
[/td][/tr][tr][td]Joe
[/td][td]2
[/td][/tr]
[/TABLE]
Sheet2
[TABLE="class: cms_table_grid, width: 500"]
Customer's Name
[/td][/tr][tr][td]Joe
[/td][/tr][tr][td]Henry
[/td][/tr]
[/TABLE]
If there is a match between (Sheet1 - Column A) and (Sheet2 - Column A) the Result will be something like Sheet3 below
Sheet3
[TABLE="class: cms_table_grid, width: 500"]
Customer's Name
[/td][td]No of Engagement
[/td][/tr][tr][td]Joe
[/td][td]3
[/td][/tr][tr][td]Henry
[/td][td]1
[/td][/tr]
[/TABLE]
Thank you in advance guys.