Formulae

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

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
 
The and so on suggests that you would want to use a VLOOKUP table. Look in
the help index for VLOOKUP. Put the formula in col c and copy down.
 
Sorry Don.
Got lost. Tried one of the examples from VLOOKUP help
and put 'my words' where I thought they should go:
=IF(ISNA(VLOOKUP(British War Medal,A2:George V,2,FALSE)) = TRUE, "xxx",
VLOOKUP(British War Medal,A2:George V,2,FALSE))
I put this in the top cell of column 2 and nothing happened,

- a little more coaching please!!
 
When all else fails, RTFI
Help suggested that you make a table of your variables

col f col g
British War George V
Crimea Victoria
then use that
=vlookup(a2,f2:g120,2,0)
 
Back
Top