How to compare two string in two different workbooks?
Hi All,
How are you doing?
Guys need your help,I want to compare a string in a different workbook. and find the relevant cell value of that.
e.x. in one worksheet the value displayed like "DEBIT/ATM CARD TRANSACTION FEE"
But in another worksheet the value displayed as "018 - Debit/Atm Card Transaction Fee".
Now I want to compare this string and the value displayed in the column E for this row of workbook 2 should be displayed in workbook 1 in the column D.
Can anybody help on this?
Thanks, have a good day !
Regards,
Somani
Attachment | Size |
---|---|
Workbook1.xlsx | 10.73 KB |
Workbook2.xlsx | 11.95 KB |
Hi Somani, You need to get a
Hi Somani,
You need to get a unique identified in both workbooks to get your desired results. Now, if you have the same pattern as you have given as "018 - Debit/Atm Card Transaction Fee", you can use a text function like:-
=TRIM(MID(A1,SEARCH("-",A1)+2,LEN(A1)))
to remove "018 - " to match it to other identifier and then you can you vlookup function to fetch the desired value.
Regards,
DILIPandey