paoyi
10-14-2013, 11:08 AM
Good week everyone
I looked in threads but cannot find an exact situation, hence this thread. I have situation with how to match 2 lists:
list-1 (bigger) contains all info (company, name, date ....)
list-2: only has email
Then what I try to do is:
Match emails in small list to the larger list, if find match, then if fill in data from B, C, D, E, F to the matched email in the small list. I attach a simple list, in reality, I have to do "FIND" for 15 emails, one by one, against a list of 200 names, then have to copy the cols 15 times -- INSANE !!! many thanks and bows :)
I looked in threads but cannot find an exact situation, hence this thread. I have situation with how to match 2 lists:
list-1 (bigger) contains all info (company, name, date ....)
list-2: only has email
Then what I try to do is:
Match emails in small list to the larger list, if find match, then if fill in data from B, C, D, E, F to the matched email in the small list. I attach a simple list, in reality, I have to do "FIND" for 15 emails, one by one, against a list of 200 names, then have to copy the cols 15 times -- INSANE !!! many thanks and bows :)