The Grim Discovery
Board Regular
- Joined
- Jan 23, 2015
- Messages
- 241
- Office Version
- 365
- Platform
- Windows
Animal | Phobic | ||
Rat | Yes | ||
Snake | No | ||
Spider | Unknown | ||
Scorpion | |||
Rat | ? | ||
Snake | |||
Rat | ? | ||
Spider | |||
<tbody>
</tbody>
Hello, how do I get all instances in Col A of 'Rat' to show in Col B as "yes"? This needs to be dynamic as the Col B could also be "no". I suppose I'm asking how can value in Col A have its associated value in Col B repeated wherever it is found? I'm INDEX/MATCHING myself to a standstill.
Thanks in advance.