import info if 2 criteria in a row are met

[robgoldstein]

Hi All,
I have a sheet called "DATA" that has dates in Column C and Email addresses in Column B
On another sheet I am going to have Email addresses (there may be 2 email addresses in a single cell separated by a "," ) in Column B and a date in Cell A1.

Is there a formula where I can pull the info in column X on the data sheet into the new sheet IF the email address and the date from the new sheet match in a row in the DATA sheet?

 

[robgoldstein]

Solved.