I'm just starting to wrap my head around the INDEX/MATCH function but can't quite get it, especially when trying to include an IF function. Not entire sure what I'm looking to do can be done so I'm challenging the experts.
I'm looking to run a formula that says, "if you find a "Yes", return anything to the left of it". Using the example below, the hope is to return a list of Red, Green, and Orange.
The below will give me "Red" but I'm struggling with how to relate this to the rest of the list. When I drag it down, I only get "Red" on the other "Yes" responses.
=IF(B1="Yes",INDEX($A$1:$A$6,MATCH(B1,$B$1:$B$6,0)))
A B
1 Red Yes
2 Blue No
3 Green Yes
4 Purple No
5 Yellow No
6 Orange Yes
Thanks in advance for your help!
Bookmarks