Dear Sir



hope you are doing well.I need a help.
My problem is:
Suppose i have the 2 attached file. now i want to put ID number thats are in column D of excell workbook 'ID No master" in column F of workbook "asia 30" if minimum 4 or more alphabet/Character of bank name and branch name (column C & D)will match with column C & D in workbook 'ID No master". Please note that the spelling of bank name and branch name in worksheet asia 30 may differ slightly from time to time as i get them daily basis from different customer.
thanks in advance for your reply.

Regards
Mahfuz

Attached Files

	Id no master.xls (79.0 KB, 10 views)
	asia30-050513.xls (26.5 KB, 11 views)

I filtered both for Janata and only one of the Branch names listed matches (Mohanpur). For the other three in Asia30 (Kachua, Sundalpur, Nangalkot), there does not seem to be a corresponding Branch in ID Master. Is that correct?

For Agrani, no problem with Narayanpur. But Brahmanbaria might be hard to resolve since it is the Branch in Asia30 is "BANGORA BAZAR BRAHMANBARIA 1441". I'm not sure how this could be done.

If I were you, I would set standards for data from the customers. Perhaps separate entry fields for Branch Name, Branch City, and Branch Postal Code (if available) and use Data validation to ensure the correct choices are made.