Hello All
Can anyone help me please? I am using Excel 365. I have two tables (all fake data):
Table 1 (A-C): Contact details of individuals
Table 2 (G-J): Orders made by individuals
My actual data is likely to be 1000s of rows. I want to be able to perform some kind of lookup between table 1 and 2, which returns any names of individuals who haven made entries in Table 2, but their contact details don't appear in Table 1. I only want to see each name once. So based on the example below, I would want to see a list showing the names, David Smith, Naomi Chillcott and Lexi Tracy.
Thanks in advance to anyone who can help.
Can anyone help me please? I am using Excel 365. I have two tables (all fake data):
Table 1 (A-C): Contact details of individuals
Table 2 (G-J): Orders made by individuals
My actual data is likely to be 1000s of rows. I want to be able to perform some kind of lookup between table 1 and 2, which returns any names of individuals who haven made entries in Table 2, but their contact details don't appear in Table 1. I only want to see each name once. So based on the example below, I would want to see a list showing the names, David Smith, Naomi Chillcott and Lexi Tracy.
Book1 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Name | Tel | Name | Data 1 | Data 2 | Data 3 | ||||||
2 | Joe Bloggs | Joebloggs@whatever.com | 1234 | Joe Bloggs | Happy | 12 | yes | |||||
3 | Amy Gee | Amy Gee@whatever.com | 15312 | Amy Gee | Happy | 45 | yes | |||||
4 | Helen Water | Helen Water@whatever.com | 1523132 | Helen Water | Excited | 1 | No | |||||
5 | Sam Franks | Sam Franks@whatever.com | 1531 | Sam Franks | Miserable | 564 | No | |||||
6 | Richard Osgood | Richard Osgood@whatever.com | 15345 | David Smith | Angry | 43 | yes | |||||
7 | Tom Pond | Tom Pond@whatever.com | 86451 | Richard Osgood | Anxious | 54 | No | |||||
8 | Charlie New | Charlie New@whatever.com | 15876 | Lexi Tracy | Happy | 74 | No | |||||
9 | Charlie New | Miserable | 23 | No | ||||||||
10 | Tom Pond | Happy | 75 | No | ||||||||
11 | Charlie New | Anxious | 1 | yes | ||||||||
12 | Joe Bloggs | Happy | 7 | No | ||||||||
13 | Amy Gee | Happy | 4 | No | ||||||||
14 | Amy Gee | Happy | 43 | yes | ||||||||
15 | Naomi Chillcott | Miserable | 1 | No | ||||||||
16 | Helen Water | Happy | 74 | yes | ||||||||
17 | Sam Franks | Anxious | 36 | No | ||||||||
18 | Richard Osgood | Happy | 4 | yes | ||||||||
19 | Tom Pond | Happy | 643 | yes | ||||||||
20 | Charlie New | Miserable | 24 | No | ||||||||
21 | Lexi Tracy | Happy | 1 | yes | ||||||||
Sheet1 |
Thanks in advance to anyone who can help.