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

AttachmentSize
Workbook1.xlsx10.73 KB
Workbook2.xlsx11.95 KB
DILIPandey's picture

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