Previous Topic Next Topic

Compare lists in Excel

Closed
NukeMe - Sep 9, 2010 at 09:21 AM
 Trowa - Sep 9, 2010 at 09:57 AM
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.


Related:

1 response

Answer 1 / 1
Trowa
Sep 9, 2010 at 09:57 AM
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Macro to compare sheets(Jan & Feb), highlight the difference, copy the comme
drsuresh26 -
ac3mark -

1 response
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response