Shiereen has attended:
Excel Advanced course
Vlookups
How to see if there are dupplicate numbers in vlookups so it doesn't just pull in the first number it finds but lets me know that there are 2 values to choose from
RE: 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
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
