Excel - Formula that skips rows if two IF logical tests aren't met

I have a table with all the data (in a tab called 'Master') which I want to get information from if it meets two criteria, and put that in another tab.

The Master tab basically laid out like this:

Name in A, Criteria 1 in B and Criteria 2 in C

Ben Yes Yes

Bob No Yes

Rob Yes Yes

This is the formula I have so far:

=IF(AND(Master!$B1="Yes",Master!$C1="Yes"),Master!$A1,"")

What I want it to do drag this formula down in my second tab so it will (in the above example) pick out Ben, ignore Bob and then in the next row pick out Rob.