Formulae
 

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

Formulae
 

Sorry - should have said Excel 2003
(and bottom posted as well!!)

"Richard" wrote in message
...
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

Formulae
 

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Richard" wrote in message
...
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

Formulae
 

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!!


"Don Guillett" wrote in message
...
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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Richard" wrote in message
...
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

Formulae
 

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)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Richard" wrote in message
...
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!!


"Don Guillett" wrote in message
...
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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Richard" wrote in message
...
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