Do you mean

=IF(F20,"new data","")

and copy to all relevant rows

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Craig" wrote in message
...
I would like to know if it is possible to find data from a column and
insert
new data in an other column if there are positive results. This would be
similar to a Find and replace function, but it would not replace the
searched
data. This has to be done several times through out the worksheet with
different data being inserted in the other column