Hi all. I have a lot of data in columns in text format that I want to
code in to whole numbers.

eg. a lot of rows in say column A than contain either "red", "blue",
"black" etc.

I need a formula (ideally able to placed on a different sheet!) for
corresponding rows in a new column eg: C, that would say: if A1 "red"
then C1=0, if A1="blue" then C1=2, if A1="black" then C1=3 and so
forth with up to 20 arguments!.

Is this at all possiable.

Thanks. Vince