Complex Logic

[mika.]

I have cell A4 whose value is dependent on the values of
A1, A2, and A3. However depending on the combination of
these three values, there are numerous different values
that A4 cam take on. Is there an easier way than nested
ands/ifs such that whenever the focus is moved from A1,
A2, or A3 to something else, A4 is updated?

Thanks so much.

 

[JohnI]

mika,

One way may be to use VLOOKUP e.g.

=VLOOKUP(A2&B2&C2,$G$2:$H$21,2,FALSE)

you'll have format the lookup column (i.e. G for above example) as TEXT.

If empty cells in your data are possible, this won't work properly unless
you also include a special character between fields e.g. # below -

=VLOOKUP(A2&"#"&B2&"#"&C2,$G$2:$H$21,2,FALSE)

regards,

JohnI