compare two columns and find the matched id

[SIRI]

i have a two columns in excel with columns names and email ids now
have to search email id comparing with the name columns and display i
in another colum

 

[Spencer101]

i have a two columns in excel with columns names and email ids now
have to search email id comparing with the name columns and display i
in another column

I'm not sure I understand what you mean...
Search in what for what and display what where?

Perhaps an example workbook would help