Excel help?!

[eran says]

Hello. I am trying to find a way to have excel assign a numerical value to a word. I have a column in which I will either be entering a client's rate per session, or their insurance company. I would like to be able to tell excel that if I type in "BlueShield", that holds a value of 75 dollars.

At the bottom of the column I would like to have excel add up the values for a total. Is there any way to do this?

 

[Chintan Gohel]

Hello. I am trying to find a way to have excel assign a numerical value to a word. I have a column in which I will either be entering a client's rate per session, or their insurance company. I would like to be able to tell excel that if I type in "BlueShield", that holds a value of 75 dollars.

At the bottom of the column I would like to have excel add up the values for a total. Is there any way to do this?

Using if functions maybe?

For example: =IF(A2="blue",76)+IF(A2="g",40)
I've kept the entries in column A and the values in column B
So if I enter Blue, the corresponding value is 76.

this could be taxing if you have a lot of values

 

[eran says]

Using if functions maybe?

For example: =IF(A2="blue",76)+IF(A2="g",40)
I've kept the entries in column A and the values in column B
So if I enter Blue, the corresponding value is 76.

this could be taxing if you have a lot of values

Thanks for the reply, I was hoping to avoid another column. Is there any way I can do that?