Hi,
I want to match two columns from two different sheets and update account numbers in results. with match , partial match and account numbers
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 |
Solved! Go to Solution.
@Felipe_Ribeir0 Thanks a lot helping for helping out