=IF(A1="red",1,IF(A1="yellow",2, etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"rasha" wrote in message
...
hello, please i want to know how can i set a categories for example to
another data example;
i want when to write red in a cell in a column the number 1 appears
automatically in another column and when to write yellow number 2 apears
...etc
thank you