VBA Code to pull data from two colums and return Yes value

Hi there,

I am currently doing some spreadsheets at work and I need either a VBA code or formula to assist in data gathering.
I have my excel spreadsheet and the data is being put into the "Summary Sheet" worksheet - this is done by selecting the appropriate information from the drop down box (attachment - screengrab 1). I would like excel to auto-populate if a location has received a certain activity into the "Activity & Location" then return a value of Yes. If it hasn't to return a blank value.

Screen grab 2 (attachement) is how i have the worksheet set up so that the manager can come in, open that worksheet and see what location has received what activity.

The formula needs to pick up if the Location (Colum A in both sheets) is the same and the activity (columns B-F in sheet2, column F in sheet1) is the same to say Yes.
It doesn't have to be VBA, it can be a formula.

Thank you