Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data lists

Data lists

ResolvedVersion 2010

Wed 14 Mar 2018, 16:27 Delegate Carl said...

Carl has attended:
Excel Intermediate course
Excel Intermediate course

Data lists

How would I take 3 separate excel workbooks or worksheets within one workbook containing lists of addresses in order to create one new sheet that contains a list of all the common/same addresses that appear on all 3 lists?

Many thanks in advance

Thu 15 Mar 2018, 14:13 Trainer Wendy said...

RE: Data lists

Hi Carl

Thank you for using the forum

Have you tried using a VLOOKUP or Index and Match to match up the data?

We have an article on Vlookups here
https://www.stl-training.co.uk/fg-30/vlookup-vs-hlookup.html

and you can download the manual that covers it here
https://www.stl-training.co.uk/excel-advanced-courses.php #free-manual

Please let me know if this helps

Kind regards

Wendy Canelas
Microsoft Trainer

Thu 22 Mar 2018: Automatically marked as resolved.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Terms & Conditions Privacy & Cookie Policy