??

[pierre]

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

=CHOOSE(MATCH(E44,"X",0),5)

=CHOOSE(MATCH(E45,{"X","Y"},0),6,7)

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

 

[Sandy Mann]

Assuming that you want the precidence to be in that order and X, Y or Z is
the only thing in the cell then something like:

=IF(E44="X",5,IF(E45="X",6,IF(E45="Y",7,IF(E46="Z",8))))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[pierre]

THANKS BUT I WOULD LIKE TO KEEP USING (CHOOSE) BECAUSE I WOULD LIKE TO AVOID
USING THE IF FUNCTION (ITS TOO LIMITED)...UNLESS IF THERE IS ANOTHER WAY.

 

[Sandy Mann]

I don't know what you mean by:

USING THE IF FUNCTION (ITS TOO LIMITED)...

It seems to me that in this circumstance CHOOSE() is the more limited but if
you must use CHOOSE() then something like:

=CHOOSE(MAX((E46="Z")*1,(E45="Y")*2,(E45="X")*3,(E44="X")*4)+1,"",8,7,6,5))

will return the number you want in the precedence that you gave.

Please don't use all upper case - there is no need to shout at me.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk