• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

find duplicate values corresponding to name

rahulsharma012

New Member
below is the link for file


http://www.fileconvoy.com/dfl.php?id=g4bc98b0fb6d7a7f39993159481a0fae723975d29e


i want empcode corresponding to the names.if there are duplicate names the empcode assigned to duplicate names should have same code.


Regards,

Rahul
 
a simple VLOOKUP will do this. In cell B2 put this:

=VLOOKUP(A2,Sheet2!$A$2:$B$4,2,0)

and copy it down.


Note that you will need to change the Sheet2!$A$2:$B$4 bit if your lookup table grows in size. If you are using Excel 2007 or greater, I'd suggest changing your lookup table to an Excel table by selecting it and pushing Ctrl + T. Then you can use this formula:

=VLOOKUP(A2,Table1,2,0)

...assuming the name of the table is Table1 (and it will be if its the only table in the workbook).


I suggest you might want to google VLOOKUP and Excel Tables to find some good background info on these two topics.
 
Back
Top