Match first & last name return value

I am trying to match a last and first name (just a few letters of the first name) and the return value is the ID number. I can't get this to work... is index match the best way or vlookup???

Here is my example. The formula is within the spreadsheet.


Thank you!

This maybe:

=LOOKUP(2,1/((A2=Sheet1!A:A)*(B2=Sheet1!B:B)),Sheet1!C:C)