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