First, the formula has to go into T2:

=if(a2=c1,s2,"not equal")

replace that "not equal" string with what you want to see if A2 doesn't equal
C1.

Barbara wrote:

WHAT IS EXCEL SYNATX FOR: IF A2=C1 THEN T2 = S2?

--

Dave Peterson