Compare lists in Excel [Closed]

Report
-
 Trowa -
Hello,

I have 3 lists.
A1:A500 contains names.
B1:B500 contains dept codes associated with names in A1:A500
C1:C500 contains names of people who have completed a task

I would like to add the dept codes from B1:B500 to D1:D500 of all people in C1:C500 who match names in A1:A500.


1 reply

Hi NukeMe,

Try this formula in cell D1, drag it down 499 cells and see if it suits your needs:

=IF(ISERROR(VLOOKUP(C1,$A$500:$B$500,2,FALSE)),"",VLOOKUP(C1,$A$500:$B$500,2,FALSE))

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!