found and insert

A..................................B
aluminium dec.................
cotton jan.....................
soybean feb..................right
oil dec
palm nov
rice dec........................right
etc

ok i need a macro if found soybean wording on row A, then B insert "right". if found rice wording on row A, then B insert "right".

how should i code thank

Hi

Assuming that your data stars in A1 then try

Please Login or Register  to view this content.

HTH

rylo

thank a lot