formulas with text
 

I have text in column B, all I need to do is create a formula so that when I
put in text in column B, it will create a number in column C! For instance, I
have CXO in column B, I need it to put 25 in column C everytime I type this.
I know this is a simple function, but have not used this version of Excel
before. Thanks in advance for any help!

formulas with text
 

I suggest you set up a vlookup table.

Create a table with all the text in 1 column and the numbers in the
next

Say this is range g1:h10
cell g1 cxo h1 25
cell g2 sdf h2 45
etc

enter text (say cxo) in cell a1
put this formula in cell b1
=VLOOKUP(A1,$g$1:$h$10,2,0)
copy the forumula down to cells b2 .. b what ever

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=552888