i would like to combine the followings in ONE single (choose) formula :

=CHOOSE(MATCH(E44,"X",0),5)
=CHOOSE(MATCH(E45,{"X","Y"},0),6,7)
=CHOOSE(MATCH(E46,{"z"},0),8)

i dont want to use IF because its limited to 7 statements.

You've posted this same question a few times now.

I'm guessing that since you haven't gotten an acceptable response that most
people don't know what you want to do when you combine the formula.

You're looking at e44, e45 and e46. What do you want the combined choice to be
based on?

If you feel that you're limited by only 7 levels of nesting, maybe you'd be
better off using a table (on a different sheet) and a =vlookup() formula.


pierre wrote:

i would like to combine the followings in ONE single (choose) formula :

=CHOOSE(MATCH(E44,"X",0),5)
=CHOOSE(MATCH(E45,{"X","Y"},0),6,7)
=CHOOSE(MATCH(E46,{"z"},0),8)

i dont want to use IF because its limited to 7 statements.

--

Dave Peterson

You seem to be "obsessed" with CHOOSE.

Why don't you explain to us what you're trying to do?

Neither of these make any sense:

=CHOOSE(MATCH(E44,"X",0),5)
=CHOOSE(MATCH(E46,{"z"},0),8)

--
Biff
Microsoft Excel MVP


"pierre" wrote in message
...
i would like to combine the followings in ONE single (choose) formula :

=CHOOSE(MATCH(E44,"X",0),5)
=CHOOSE(MATCH(E45,{"X","Y"},0),6,7)
=CHOOSE(MATCH(E46,{"z"},0),8)

i dont want to use IF because its limited to 7 statements.