Converting Specific Text Data to = # value

AphroHeidi - Mar 5, 2009 at 12:19 PM
 AphroHeidi - Mar 5, 2009 at 12:26 PM

I am trying to take a column that has the name of a plan type (e.g. The Fun Plan 25) and make it so the column next to it automatically recognizes that "The Fun Plan 25" is $433.00. I want to take a column of eight or so different plans and have the prices automatically show in the column next to it for averaging purposes...can you hlep me out? I appreciate any advice you have!!! I have a huge amount of data to hand type if I don't get some help on this...thanks so much!

1 reply

I am not sure why it says Windows 200 for my configuration....that is actually Windows 2007...iit might make a difference...thanks again!