Finding a Value and inserting a value in another cell

C

Craig

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
 
B

Bob Phillips

Do you mean

=IF(F2>0,"new data","")

and copy to all relevant rows

--

HTH

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