Compare lists in ExcelClosed

Question

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.


Configuration: Windows XP / Internet Explorer 7.0

Trowa · Answer

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

Compare lists in Excel

1 response

Similar discussions

Subscribe To Our Newsletter!