Using Index Match to return a text value

Hi,

I have a list that contains figures alongside people's names, which indicates those people have completed a particular task. I want to consolidate the responses into one list to simply show 'Yes' if a person has completed the task on a certain date.

I have attached an example. The first tab is how I would like the formula to return 'Yes' if there is a figure in the corresponding column on the second 'data' tab. For example on the data tab for Bob there is a figure 3 for 1/3/18. On the first tab I don't want it to return the figure 3 which I could of course do with an index match formula. Instead I want to modify the formula to do an index match however return 'Yes' instead of the figure in the column on the first tab.

Thanks

Awesome thanks so much, works perfectly!

Fantastic thank you, works perfectly!!