I am trying to lookup 2 values in sheet2 which should go into sheet1. I'll
try to explain.

Sheet 1 needs to look up the name of a person that is in both sheets.
Sheet2 contains all the infomration and the name appears more than once.

I want the cell too automatically look up the name.
After that it needs to look up for the number of "yes" values that are in
sheet 2 clumn D linked to the name on sheet 1 column B

I've tried so many different things but not sure how it should be
Hope this makes sense