Finding the last occurrence of text in a column to result in adjacent cell value

This is the current formula that works well when copied down, but now I want the false value to no longer be "", and instead be the value that is 2 columns adjacent to it.

=IF(OR(F2="Craps",F2="$$$",F2="PtEst"),"ComeOut","")

For instance, when this formula is in cell G3, I want it to return the value in E2. However, this is not a consistent relative reference.

This needs to be conditional based upon the previous cell being true/false, and want the result to be from the most recent "ComeOut" to take the value in the same row as the most recent "ComeOut" and return the value in column E that corresponds with that row of the most recent "ComeOut".

Any help or insight is greatly appreciated.

![1]: http://ift.tt/1cgivKM