wrote:
Dear All

i have one control sheet which contains all the details of clients
according to their account no. and the amount.
There is one more file which i receive on daily basis from my Central
office which again contains details of some clients,now my job is to
match up this data and send again with match and unmatch details to
central office.
Currently i am using vlookup function manually to doing this activity
but at the colume increases it become very time consuming and there
are chaces of error too when there are two different beneficary for
same client with the same amount.

Is there any macro available for it?

Regards

I described a couple ways to tackle locating columns in these posts
yesterday (watch for word wrap):

http://groups.google.com/group/micro...82baaa76208943

http://groups.google.com/group/micro...7f6f3d400d78b4


When more than one beneficiary exists per client with the same amount,
what do you want to return in the lookup?