Converting Specific Text Data to = # value

Hello,

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!