Entered in B2

=IF(A1="y",C2,D2)

Other than that......yes, I am confused.

Perhaps as Biff mentions, you are trying to push rather than pull.

Which cell has the formula entered?


Gord

On Sat, 10 Nov 2007 11:39:00 -0800, Les G
wrote:

I think I confused everyone when I mentioned Y & V values... I want to try
something like IF(A1="Y",B2=C2,B2=D2), but I get FALSE in the
'input cell.. not exact formula being used, but I hope you get the gist



"Gord Dibben" wrote:

In B2 enter =IF(A1="x", "y")

If many of these, perhaps a VLOOKUP table and a VLOOKUP formula in B2 would
suffice?

Of simply =LOOKUP(A1,I1:I10,J1:J10) where I1:I10 hold the "x" values and
J1:J10 hold the "y" values.


Gord Dibben MS Excel MVP


On Sat, 10 Nov 2007 10:55:00 -0800, Les G
wrote:

I am fairly clued up with VB, but want to try cut down using VB when
designing spreadsheets... Is it possible to have a function (e.g. If
function) post a result into an alternative cell dependant an the value in
the 'input' cell?
i.e. If A1 = X value then B2 = Y value