how can i define data by another

R

rasha

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
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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