cannot get IF statment to return data on entire column

[techspec]

Hi All
need a little help
i am cleaning up some xls'. im not sure if i am on the right path however
could anyone reccomend a fix for the following

i have names from one sheet in coulum
A
i have names from another sheet in column
C
i have their emails in column
D

A and C are from diffferent sheets/data and do not match, so i cant sort them.
i would like to populate B with emails from D IF they are present or match ( A and C)
like i said i am not a hundred percent sure i am on the right track, but i have washed the data so the names in A and C are the same.
i have used the IF formula to work a little however i would like it to search the entire column not just the one row
id like a more expansive IF than

Please Login or Register  to view this content.

< i think that's how i used it.
i tried something like

Please Login or Register  to view this content.

but it didnt work...
with my limited formula i get results like

(a)______ (b)___________(c)___(d)
bob(formula returns email) bob email
tom (formula returns email) tom email
harry (formula does not return email) garry email
garry (formula does not return email) harry email

thanks for any input.
if you can find a forumla to populate col B, id be most appreciative
-edit hope this complies with the rules and the eg book is okay.

[shg]

Welcome to the forum, techspec.

Please take a few minutes to read the forum rules, and then amend your thread title accodingly, then someone will help get you sorted.

Thanks.

[JBeaucaire]

Create a good sample set of data, 10-20 rows to make it perfectly clear. Point out your desired results.

Click GO ADVANCED and use the paperclip icon to post up your workbook.


(after you edit your title, we need that fixed to follow the forum rules)

[DonkeyOte]

Based on your sample (and version) perhaps:

B1: =IF(ISNA(MATCH($A1,$C:$C,0)),"No email present",VLOOKUP($A1,$C:$D,2,0))
copied down

[techspec]

you sir or madam have won me the day, i tip my hat.