Partial Match Columns Data within two sheets

[satish78]

Hi Friends,

I did research related to my task but did not find exactly what I am looking
Trying to partial match Sheet1 columnA with Sheet2 ColumnA and sheet1 ColumnB with sheet2 ColumnB and get corresponding sheet2 columnC data to sheet1 columnC.

If possible, also Reverse lookup and partial match sheet2 row3 data with sheet1 row5 (because "ross land" and "Developer/engineer" with Sheet1 row5 is partial name matched)

Need VBA/Index match

Here is an example data
Sheet1

Ross Land Front-End Developer
Raj Parmar Application Architect / CTI
Shraddha Pathak Software Engineer at F.M.Howell
Mathew Rawlinson Program Director, Digital
Ross Land Developer/engineer
Aaron Nguyen Ecommerce at Deep

Sheet2
Ross Land Front-End Developer ross@gmail.com
Raj Parmar Application Architect / CTI .Net and C++… raj@gmail.com
Ross Land, CFO Developer/engineer rossj@gmail.com
Shraddha Pathak Software Engineer at F.M.Howell shraddha@gmail.com
Mathew Rawlinson Program Director, Digital TV & Applicati… mathew@gmail.com
Aaron Nguyen Ecommerce at Deep Discount Servers Aaron@gmail.com

Please help me

 

[oldbrewer]

is column A just names ?

 

[satish78]

yes, just names only.

 

[satish78]

Can anyone help me please?.

 

[oldbrewer]

Ross Land Front-End Developer		9	Ross Land	2
Raj Parmar Application Architect / CTI		11	Raj Parmar	1
Shraddha Pathak Software Engineer at F.M.Howell		15	Shraddha Pathak	1
Mathew Rawlinson Program Director, Digital		16	Mathew Rawlinson	1
Ross Land Developer/engineer		9	Ross Land	2
Aaron Nguyen Ecommerce at Deep		12	Aaron Nguyen	1
Sheet2
Aaron Nguyen Ecommerce at Deep Discount Servers Aaron@gmail.com		12	Aaron Nguyen
Mathew Rawlinson Program Director, Digital TV & Applicati… mathew@gmail.com		16	Mathew Rawlinson
Raj Parmar Application Architect / CTI .Net and C++… raj@gmail.com		11	Raj Parmar
Ross Land Front-End Developer ross@gmail.com		9	Ross Land
Ross Land, CFO Developer/engineer rossj@gmail.com		9	Ross Land
Shraddha Pathak Software Engineer at F.M.Howell shraddha@gmail.com		15	Shraddha Pathak
by stripping out the names you can search for duplications
we have just 1 in this example
probably I would sort the lower table into ascending order
not sure what you want now

<colgroup><col><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>

 

[satish78]

https://spaces.hightail.com/receive/SEPSPmjJHx

Here is sample workbook with 2 sheets with formula.
formula works on exact match but not partial match and does not go if the ColumnA has duplicate name.

 

[oldbrewer]

sorry - I never download

 

[satish78]

That is the safe link and can be downloaded.

 

[oldbrewer]

sorry it is a matter of principle - put it on google sheets ??

 

[satish78]

This formula does "Exact Match" =INDEX(Sheet2!C:C,MATCH(1,(A1=Sheet2!A:A)*(B1=Sheet2!B:B),0))
But I need "partial Match" formula.
Can anyone modify or provide me VBA code for above task?.