Compare lists in Excel

 Trowa -

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:


Best regards,