insert bonus and house hold number

[mathanraj76]

Hi..
I need help

I have data1 ,data2

if data1 name in column b2 is match with in data2 name in column b2 then copy into output sheet for data1 and insert column C "BONUS CARD NUM" and column D "HSE ACC NUM" from data2 next to name..into output sheet..

I have attached sample data.


Thanks
Mraj

[AB33]

Try the attached.

[mathanraj76]

pro_1.xlsmThanks for reply..

But here i still have problem where the data1 in column b match with data2 in column b and get the bonus and house hold number ..
But i get the result is the name which match with data1 and data2 with bonus .house hold number is really different

I have attached the program with data..



Thanks
Mraj

[AB33]

Mraj,
I do not understand what the issue is. If you look at the attached, the output after running the code is the same as the output you have included. check both out puts. There are the same.

[mathanraj76]

Hi..
Thanks for reply..

What I mean is

In data1 Have company name "HAW WEA TRADING" and in Data2 have same company name"HAW WEA TRADING" and the code "6018 8400 9347 8366" "09686859"
but after run the progam and match name in data1 and data2
the output for "HAW WEA TRADING" and the code is "6018 8400 9347 8556" "09686878"
but the actual code for "HAW WEA TRADING" is "6018 8400 9347 8366" "09686859"


where the code different and the output for this is code belong to "CHUAN LIEW HARDWARE"


same as all the code in output..


Thanks
Mraj

[AB33]

Try the attached.