Index and Match with multiple columns/rows

Hello all, I need help with a project. I have a list of client names and advisors that I need to cross reference with a full client list. I could use Access and run a join but I need to be able to keep this worksheet updateable for people who don't know Access. Here is a dummy file. Sheet 1 has the list with missing PIN number that I need from sheet 2 which is the full client list. To filter, I need to match the adivsor name and client name. Thanks