software

I want to set up a condtional formula that if I would enter a word like star
I would get a numercial result in the cell next to it like number 55, If I
type the word finsih in the same cell I would get a result 95

can this be done?

Only 2 values, just use

=IF(A2=quot;starquot;,55,if(A2=quot;finishquot;,95,quot;quot;))

if more values use a vlookup formula--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;abequot; gt; wrote in message
...
gt;I want to set up a condtional formula that if I would enter a word like
gt;star
gt; I would get a numercial result in the cell next to it like number 55, If
gt; I
gt; type the word finsih in the same cell I would get a result 95
gt;
gt; can this be done?