=if(condition,action,if(condition,action,If(condit ion,action,"")))

=if(Variables!C12="A1",Variables!D52,If(Variables! C12="A2",Variables!D54,If(
.. . .

--
Regards,
Tom Ogilvy

"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 the question by Phil were very clear. Thank you. It also helped me.

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

Is there a way to also make each of the actions change the format of the cell - such as fill color and font color?
--
Robert


"Tom Ogilvy" wrote:

=if(condition,action,if(condition,action,If(condit ion,action,"")))

=if(Variables!C12="A1",Variables!D52,If(Variables! C12="A2",Variables!D54,If(
.. . .

--
Regards,
Tom Ogilvy

"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


"Tom Ogilvy" wrote:

=if(condition,action,if(condition,action,If(condit ion,action,"")))

=if(Variables!C12="A1",Variables!D52,If(Variables! C12="A2",Variables!D54,If(
.. . .

--
Regards,
Tom Ogilvy

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