patrick_oneal
New Member
- Joined
- Nov 14, 2016
- Messages
- 12
Name | Type | Clean Data | DOGS | CATS | |
FRANK | -DOG | DOG | FRANK | JEFF | |
JEFF | -CAT | CAT | AMY | KELLY | |
KELLY | -CAT | CAT | |||
AMY | -DOG | DOG |
<tbody>
</tbody>
Cells E/D (DOGS,CATS) is what I want the output to look like, I want to match all data in the C column to cell E1 (DOGS), and display the name.
Code:
{=INDEX($A$2:$C$5,MATCH($E$1,$C2:$C$5,0),1)}