Forum Discussion
Excel formula help for auto populate
This is what I am trying to so we have 4 predfined values for column 'A' For example (P,Q,R,S) and I want a formula to be automatically inserted in the Column 'B' as per the option I choose in col...
As an alternative to Nested IFs, you may use CHOOSE, as follows:
=CHOOSE(MATCH(A1,{"P","Q","R","S"}),
"x+y","x-y","x*y","x/y")
=CHOOSE(MATCH(A1,{"P","Q","R","S"}),
"x+y","x-y","x*y","x/y")