Check for name and surname matching an email address

Hi there, this inexpert excel user needs help with a task. I've got to use a formula to check if there is a name and surname listed in the data sheet corresponding with a given email address.

So I need to enter the formula here, where you can see the corresponding email addresses. The formula should allow me to retrieve the first and last name associated with the corresponding email address, and if there's no corresponding email address and names, it should print "not found"

screen1.png

And here's the data sheet, named "data." This screenshot shows the full data range on the sheet. Thanks for your help!

screen2.png

Hi AliGW, thanks for your reply, I've updated my profile

I wonder if you might be able to walk me through the process in a little more detail please? Are those examples on the link you gave me what I should be working from? My name really does reflect my knowledge sorry.

Thanks so much! Yes, I'm not ashamed to admit my lack of expertise and I really appreciate your help. Super quick too.

Cheers, sorted. I popped you a quick rep add earlier