Email Comparison Formula Needed

Hello Community,

I am looking for some help with an email IF Statement and a formula to more information, when a match is detected.

I have a couple sets of 3 columns each: Email, First, Last and I need to compare Email with other sets of Emails. 

NOTE: The 2nd or 3rd or 4th set of Email, First, Last will not have First and Last names populated, only Email.

Example:

Email              | First | Last ||| Email               | First    | Last   ||| Email               | First    | Last

test@test.com  Bo      Sam    test@test.com   Empty  Empty    Test@test.com  Empty   Empty

I need an IF statement to compare against the other Email columns to see if Email is a match to the master Email in the very first column. If any Emails match anywhere in the column, I would like SS to move over the First and Last to the matched Email.

Hopefully, that makes sense.

Rowdy