• 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.

Vlookup or Match values

A

avindia

New Member
I have 1st Column with Names and 2nd column with some values against it.Now I have third column which has Names also Names from some other excel sheet.

1. I want to match Column 1 and 3 for duplicates and show the duplicates in Column 4

2. Once Duplicate Matche found I want 2nd Column Value copy next to Names in Column 3.


I am able to achieve 1st step with Vlookup but need answer for 2nd step.


Reason- Values should match to Third column without sorting etc.


Example below

A B C D E

John 50 Avi

Avi 30 Chris

Chris 20 David

David 30 John

Peter 20 Peter

Senthil 10 Raju

I want New Column D should show value in Column B if Column C value Matches with Column A.

Output should be like below

A B C D E

John 50 Avi 30

Avi 30 Chris 20

Chris 20 David 30

David 30 John 50

Peter 20 Peter 20

Senthil 10 Raju NA
 
Hi, avindia!


I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community works.

Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet. I did that and for this case (extract duplicate list another column) you might want to start with this link:

http://chandoo.org/wp/2008/11/06/unique-duplicate-missing-items-excel-help/


Changing the keywords you'll be led thru a wide variety of articles and posts.


Regards!
 
You must log in or register to reply here.
Back
Top