Compare lists in Excel

NukeMe - Sep 9, 2010 at 09:21 AM
 Trowa - Sep 9, 2010 at 09:57 AM

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 response

Hi NukeMe,

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


Best regards,