ah the wonderfull V lookupwins again!
you need to make a table somewhere with your colours listed in one column
just say D1 down to D50.In E1 to E50 you have your assigned numbers
in a3 you have your formula of =Vlookup(a1,D1:e50,2,false)+a2
The only variation is your addition number is also in a cell,in this case A2
--
paul

remove nospam for email addy!



"modicon2" wrote:


Sorry about any confusion.
I tring to make a work sheet that can use TEXT (I want to assign a
number/constant to each unique TEXT) in math formulas.

I want to define the word/text "Red" = 10, "Green" = 11 and etc.

so that when I use a formula like = A1 + 2
(where Cell A1 has the word "Red" in it)
the result would be 12.

(Where Cell A1 has the word "Green" in it)
the result would be 13.

Thanks again


--
modicon2
------------------------------------------------------------------------
modicon2's Profile: http://www.excelforum.com/member.php...fo&userid=4158
View this thread: http://www.excelforum.com/showthread...hreadid=573268