Hello everyone,

I'm trying to figure out a way to accomplish the following:

A B C D E
1 Tom Tom Yes
2 Joe Bob
3 Ryan Joe Yes
4 Bill Ryan Yes
5 Chris
6 Frank
7 Bill Yes

In column A I would like a formula to populate the name of a person from column D only if column E says Yes.

As column E changes so will column A

Any help is much appreciated!

Thanks in advance,

-Justin