Partial match of Columns from two different sheets

[KamalChoudhary_in]

Hi,

I want to match two columns from two different sheets and update account numbers in results. with match , partial match and account numbers 

• Using (Companies_Name) in  KYCPIVOT sheet, search for them in the (Sec_Companies)Column B of another sheet  NO_KYC

• Result should include non-exact match between (Companies_Name) in  KYCPIVOT sheet and (Sec_Companies)Column B of another sheet  NO_KYC

• After determining the matching and partial match between (Companies_Name) and (Sec_Companies) summarize the account numbers from NO_KYC sheet to KYCPIVOT Sheet and transpose them in

Note – Part is the string match is required to match multiple miss match and data is in two different tabs and columns.

Input 

KYCPIVOT

Companies_Name

Aramco

Aramco N.V

Aramco  N.V.

Input

NO_KYC
Account	Sec_Companies
465464	Aramco NV
65464654	Aramco NV
65464654	Aramco NV
56464	Aramco NV
64654	Aramco NV

Output 

Result Expected
Companies_Name	Status	Account 1	Account 2	Account 3	Account 4
Aramco	Partial Match	465464	65464654	56464	64654
Aramco N.V	Partial Match	465464	65464654	56464	64654
Aramco  N.V.	Partial Match	465464	65464654	56464	64654

[Felipe_Ribeir0 · Accepted solution]

Hi @KamalChoudhary_in 

One way of doing this using fuzzy match:

[KamalChoudhary_in]

@Felipe_Ribeir0 Thanks a lot helping for helping out