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