Lookup based on Cell Criteria

Hi There,

I'm half way into the supposedly easy calculation, but need some help. I've entered the formula which when equal to "approve" should give me only the details where it matches from another sheet. So if its "approve" then it should give me the name and other details.. I've attached the spreadhseet to make some sense, I need some help here please.

Thanks,