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,(E 44="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


Replace @mailinator.com with @tiscali.co.uk


"pierre" wrote in message
...
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.




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

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

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