Partial match of Columns from two different sheets

Question

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

KYCPIVOTCompanies_NameAramcoAramco N.VAramco  N.V.

Input

NO_KYCAccountSec_Companies 465464Aramco NV65464654Aramco NV65464654Aramco NV56464Aramco NV64654Aramco NV

Output

Result ExpectedCompanies_NameStatus Account 1Account 2Account 3Account 4AramcoPartial Match465464654646545646464654Aramco N.VPartial Match465464654646545646464654Aramco  N.V.Partial Match465464654646545646464654

Felipe_Ribeir0 · Accepted Answer

Hi @KamalChoudhary_in

One way of doing this using fuzzy match: