Link to home
Start Free TrialLog in
Avatar of rob700
rob700

asked on

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
Avatar of NBVC
NBVC
Flag of Canada image

Are the duplicates going to have differences in the other columns?

At first glance they don't seem to.
ASKER CERTIFIED SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rob700
rob700

ASKER

No they were all the same. Thank-you!