I have two tables, people and jobs, on two separate sheets. How do I find the names of the people who:
- Are not in their dream jobs
- Their dream job is available in the jobs table?
People
| | A | B | C | D |
| 1 | name | Job | Dream Job | In Dream Job? |
| 2 | Joe | Dentist | Plumber | False |
| 3 | Jim | Waiter | Laundry | False |
| 4 | Jane | Author | Author | True |
| 5 | Jack | Brewer | Wretch | False |
Jobs
| | A | B |
| 1 | id | Job |
| 2 | 1 | Dentist |
| 3 | 2 | Waiter |
| 4 | 3 | Author |
| 5 | 4 | Plumber |
| 6 | 5 | Laundry |
In this case, the expected output would be the following:
| | A | B | C |
| 1 | name | Job | Dream Job |
| 2 | Joe | Dentist | Plumber |
| 3 | Jim | Waiter | Laundry |