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?
| | 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 |
| | 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 |