formulas with text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top