Simple vlookup

It's been a while since I've used the vlookup formula, and I'm sure this has a simple solution. I've attached a file to help out. What I need is to return a name from Sheet1 that has a value of "Yes" into cell A1 on Sheet 2. In this case, I would need cell A1 to return "G." Also, is it possible to return more than one name if multiple entries have the same value? For example, if G and H both had values of "Yes?"

Try the INDEX/MATCH lookup...
=INDEX(Sheet1!A2:B27,MATCH("Yes",Sheet1!B2:B27,0),1)

Thanks, that did it. But is there a way I could get it to return multiple names that have the same value? So if names G and H both had values of "Yes," could cell A1 read G and cell B1 read H?