If-Then Formula
 

=IF(Variables!C12="A1",Variables!D53,IF(Variables! C12="
A2",Variables!D54,IF(Variables!C12="A3",Variables! D55,"")))

--
HTH

-------

Bob Phillips
"Phil Hageman" wrote in message
...
This is a re-post of a previous request, explained differently - I need a
single formula to do the following:

Variables is the name of a worksheet
This formula is located in another worksheet named Scorecard

If Variables!C12="A1", then populate cell with Variables!D53
If Variables!C12="A2", then populate cell with Variables!D54
If Variables!C12="A3", then populate cell with Variables!D55
If Variables!C12 is blank, then populate cell with blank.

If-Then Formula
 

Thanks, Bob - works exactly as needed.

"Bob Phillips" wrote:

=IF(Variables!C12="A1",Variables!D53,IF(Variables! C12="
A2",Variables!D54,IF(Variables!C12="A3",Variables! D55,"")))

--
HTH

-------

Bob Phillips
"Phil Hageman" wrote in message
...
This is a re-post of a previous request, explained differently - I need a
single formula to do the following:

Variables is the name of a worksheet
This formula is located in another worksheet named Scorecard

If Variables!C12="A1", then populate cell with Variables!D53
If Variables!C12="A2", then populate cell with Variables!D54
If Variables!C12="A3", then populate cell with Variables!D55
If Variables!C12 is blank, then populate cell with blank.

If-Then Formula
 

The answers by Bob and Tom to Phil's question were very clear. They helped me also. Thank You!

An add-on question, if you don't mind...

Is there also a way to conditionally change the cell format at the same time as we change the value - such as font and fill color?

--
Robert


"Bob Phillips" wrote:

=IF(Variables!C12="A1",Variables!D53,IF(Variables! C12="
A2",Variables!D54,IF(Variables!C12="A3",Variables! D55,"")))

--
HTH

-------

Bob Phillips
"Phil Hageman" wrote in message
...
This is a re-post of a previous request, explained differently - I need a
single formula to do the following:

Variables is the name of a worksheet
This formula is located in another worksheet named Scorecard

If Variables!C12="A1", then populate cell with Variables!D53
If Variables!C12="A2", then populate cell with Variables!D54
If Variables!C12="A3", then populate cell with Variables!D55
If Variables!C12 is blank, then populate cell with blank.

If-Then Formula
 

The answers by Bob and Tom to Phil's question were very clear. They helped me also. Thank You!

An add-on question, if you don't mind...

Is there also a way to conditionally change the cell format at the same time as we change the value - such as font and fill color?

--
Robert


"Bob Phillips" wrote:

=IF(Variables!C12="A1",Variables!D53,IF(Variables! C12="
A2",Variables!D54,IF(Variables!C12="A3",Variables! D55,"")))

--
HTH

-------

Bob Phillips
"Phil Hageman" wrote in message
...
This is a re-post of a previous request, explained differently - I need a
single formula to do the following:

Variables is the name of a worksheet
This formula is located in another worksheet named Scorecard

If Variables!C12="A1", then populate cell with Variables!D53
If Variables!C12="A2", then populate cell with Variables!D54
If Variables!C12="A3", then populate cell with Variables!D55
If Variables!C12 is blank, then populate cell with blank.