try this:

=IF(ISERROR(MATCH(C18,$A:$A,0)0),"",A$2)

A2 where the date is, assuming its location does not change
C18 where E is

if it doesn't work give me more detail.

Thanks-
"Karaman" wrote:

This is the setup:
Table 1
Column 1 Column 2
Date1 Date1
Date2 Date2
A C
E B

Table 2
String1 Column A Column B
E

Task: For cell in Table 2 column A, find if "E" is present in Column 1 of
Table 1, then read Date 1 into the cell, otherwise leave blank. Thank you
and I hope that you can help me with this one.