if I understand your need
in col c copied across to c and changed to suit text
=IF(A2=$A$1,"no","")
in col f
=IF(COUNTIF(A2:C2,$A$1)=3,"Hit","")
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Alvaro" wrote in message
ps.com...
Please, I need a for me complex formula to do the following:

1. if line 1 = line 2 in column A, then "No." in column C, if not then
" ",

2. if line 1 = line 2 in column B, then "Date" in column D, if not
then " ",

3. if line 1 = line 2 in column C, then "Amount" in column E, if not
then " ",


4. if line 1 = line 2 in column A and if line 1 = line 2 in column B
and if line 1 = line 2 in column C, then "HIT" in column F, if not
then " "

Thanks for your effort.

Alvaro