Lookup match index multiple values return other columns

Hi all,

I'm a super newbie... please go easy on me

Attached is my sample data...

I need to match the names in column E with the names in A,B and C... and return column d...

I don't think V-lookup will be of any assistance as there will be duplicates of even the most uncommon surnames.

It is also possible that the middle name won't be in column B even if there is one in column E

If there is no middle name in column E there will be 2x spaces between the first name and last name as per E5

Cell E3 worries me with a surname that has a space in it "Le Royer"

I was thinking INDEX and MATCH but was unsure how to use this with an "IF" or if more than one match is required

Thanks in advance for your help!