.... or =IF(AND(B1,D1=D2),"Match","")
--
David Biddulph

"Rick Rothstein" wrote in message
...
I think you are looking for this...

=IF(B1,IF(D1=D2,"Match",""),"")

Put it in C1 and copy down.

--
Rick (MVP - Excel)


"< AVG Joe" wrote in message
...
Perplexed-
How do I check a condtion say If(Bw=TRUE),
Then compare cells D2 & D3 for equality)
and repeat for about 1000 rows?
Example:
A B C
D E
1 N TRUE If (B1=True, If(D2=D3), "MATCH") Q
2 N FALSE If (B2=True, If(D2=D3),"") Q
3 Y TRUE If (B3=True, If(D3=D4), "MATCH") Y
4 Y FALSE If (B4=True, If(D4=D5), "") Y