Solved

Vlookup - match to duplicates

Posted on 2014-04-14
3
366 Views
Last Modified: 2014-04-14
Sheet one contains a list of stock codes with duplicates throughout.

I am trying to match the corresponding information in sheet two to each stock code in sheet one including duplicates.

I've tried using a vlookup but for some reason its not working for all duplicates???

Thanks
Rob
Excel-Question--vlookup-2.xlsx
0
Comment
Question by:rob700
  • 2
3 Comments
 
LVL 23

Expert Comment

by:NBVC
ID: 39998874
Are the duplicates going to have differences in the other columns?

At first glance they don't seem to.
0
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39998887
If there are not differences, try this formula:

=INDEX(Sheet2!B:B,MATCH($A2,Sheet2!$A:$A,0))

If there are differences, we will need to use helper columns, or array formulas.
0
 

Author Comment

by:rob700
ID: 39998907
No they were all the same. Thank-you!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delete all words in cell more than 5 words 7 47
Match formula returns N/A 5 25
Adding Text that self adjusts in a Cell 8 31
highlight duplicate entry 16 27
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now