Greeting all.

I have a table with two columns -
Medal Name - Monarch

Column 1 has the data entered.
Can I apply a conditional formula to column
2 something to the effect of:


If MEDAL NAME=British War Medal then George V
else
If MEDAL NAME=Crimea Medal then Victoria
and so on

As column 1 already has data in, will a formula
autofill column 2 or will it only apply for new entries

If it is possible, now the really dumb question - where do
you enter the formula?

Thanks from a total newbie