in a formula in col b
=if(cond,a1,"")
using vba
for each c in range("a1:a100")
if cond then c.offset(0,1)=c
next
--
Don Guillett
SalesAid Software

"Jim" wrote in message
...
I need to search through a column checking condtions. If the conditions
are
met, then I want to enter the corresponding value in the column next to it
into a different cell. Basically, I want to search column A and, if the
conditions are met, put the value in B into C. Would this be easier via
formula or code? And maybe some starting suggestions would be nice if you
don't mind.
--
Thanks,
Jim