Merging data from two sheets where match is found

Sheet 1 Column A has a list of names to be found in Sheet 2 Column A names.

Here is what I am doing to find out if a matching name is found in sheet 2.

=IF(ISNA(VLOOKUP(A4,Sheet1!A$2:A$770,1,FALSE)),"No","Yes")

But instead of saying "Yes" (that a match was found)... I would like to get the rest of that matching rows data.

For example: Lets say we found a match on the name Peter (Sheet 1 A15). Now in sheet 2 I want my formula to give me Peter's last name which is found in Sheet 1 B15, then Peters middle inital (Sheet 1 C15).

I am just having trouble returning the matching row back to my formula and using that to get more information. Can anyone help?

Thank you!

Perfect!!!