Formula to match names between sheets and pull another field if there's a match

[shawnus]

Hello and thanks in advance,

I have 2 sheets containing user data- one sheet named 'DATA' which contains "User Full Name" (in column E) and the other sheet named 'NAMESANDEMAILS' which contains "User Full Name" (in column C) along with "Email Address" (in column D of 'NAMESANDEMAILS').
I need a formula to look up the "User Full Name" from the 'DATA' sheet and match it to the "User Full Name" from the 'NAMESANDEMAILS' sheet and if it finds it to then retrieve the "Email Address" from this sheet and populate it into the "Email" (column F) within the 'DATA' sheet.

I know this probably isn't too difficult but I can quite seem to crack it. I have Excel 2019.

Thanks!

 

[Fluff]

How about

=index(NAMESANDEMAILS!d2:d1000,match(e2,NAMESANDEMAILS!c2:c1000,0))