Thread: Help assigning a number to a word
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
modicon2 modicon2 is offline
external usenet poster
  
Posts: 1
Default Help assigning a number to a word

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

Reply With QuoteReply With Quote