Vlookups

Hi Shiereen

Thanks for getting in touch. There are some ways to do this but they are all quite complicated. You can find some creative solutions at this link, but I warn you none of them are straightforward:

http://www.mrexcel.com/forum/excel-questions/4266-vlookup-duplicate-data-2.html

You may find it easier if possible to generate a unique value for your data that you can use, or use a COUNTIF function to figure out how many of each value there are first.

I hope this gives you some ideas.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector