Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data lists
Resolved · Urgent Priority · Version 2010
Carl has attended:
Excel Intermediate course
Excel Intermediate course
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
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.
|
Excel tip:Changing the Tab Colour of an Excel 2010 WorksheetDid you know you could give the tabs in your worksheet different colours? |
We'll call during UK business hours
Server loaded in 0.07 secs.