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