[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 393
  • Last Modified:

Vlookup - match to duplicates

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
rob700
Asked:
rob700
  • 2
1 Solution
 
NBVCCommented:
Are the duplicates going to have differences in the other columns?

At first glance they don't seem to.
0
 
NBVCCommented:
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
 
rob700Author Commented:
No they were all the same. Thank-you!
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now