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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
data lists

ResolvedVersion 2010

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

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.

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.