charlie637
New Member
- Joined
- Jun 8, 2017
- Messages
- 17
Trying to solve this.
What I want: Formula in column D saying Yes or No based on following rules:
If a cell in Col. B equals "Bob", then look everywhere in Col. A with the same content, for ex "A1", and if in Col C there is "17", then put "Yes" in D on same row as Bob.
Otherwise, "No", as shown in D6.
If B contains no "Bob", nothing happens (could return "No" or nothing)
<tbody>
</tbody>
What I want: Formula in column D saying Yes or No based on following rules:
If a cell in Col. B equals "Bob", then look everywhere in Col. A with the same content, for ex "A1", and if in Col C there is "17", then put "Yes" in D on same row as Bob.
Otherwise, "No", as shown in D6.
If B contains no "Bob", nothing happens (could return "No" or nothing)
A | B | C | D | E | |
1 | A1 | Bob | Yes | ||
2 | A1 | Pet | 17 | ||
3 | A1 | John | |||
4 | A2 | Mike | 17 | ||
5 | A2 | Jen | |||
6 | A2 | Mary | |||
7 | A2 | Bob | Yes | ||
8 | A3 | John | |||
9 | A3 | Jack | |||
10 | A3 | Lisa |
<tbody>
</tbody>