=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.

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.

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.

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.