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.
