How to compare two string in two different workbooks?

[somani123]

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

[mahaveersomani]

use this formula in workbook1 Cell D2.

and drag the formula.


hope it will helps


Thanks & Regards
CA Mahaveer Somani
8875008725

[somani123]

Thanks Mahaveer.

If possible can you help me for VBA code.

Thanks in advance.

[somani123]

Thanks Mahaveer.
Can you help me for VBA code?

Thanks in advance.

[mahaveersomani]

use this code.

hope it will help.


Thanks & Regards
Chartered Accountant Mahaveer Somani
+91-8875008725

[somani123]

Thanks Mahaveer.

Can u plz explain me the logic?

Thanks.

[somani123]

Thanks Mahaveer.

Can u plz explain me the logic?

I tried this formula but some of the records are missing.

Can u plz help me?

Thanks.