Thread: Help assigning a number to a word
View Single Post
  #1   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

Greetings,
I would like to assign a number (exm:10) to the word "Red".
so that..
Cell:A1 has the word "Red"
Cell:B1 has a number..lets use 2
Cell:C1 has the formula "=A1+B1
I want the result to = 12 [exm:(Red which is 10 + 2)=12]

My wookbook will end up with about 50 different words assinged to 50
different numbers.

anyhelp would be greatly appreciated.
Thanks!


--
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