Retrieving Matching Emails

[sathishkm]

Hi All,

I have a two excel files. In file1 I have few message and email in a column A and in file2 I have only email. Now how I want to match file2 email with file email. How can I do. Kindly check the attachment.

[popipipo]

=IFERROR(VLOOKUP("*"&A2&"*",[File1.xlsx]Sheet1!$A$2:$A$9,1,0),"")
Does this work?

[sathishkm]

Thank YOu.