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
Replace @mailinator.com with @tiscali.co.uk
"pierre" wrote in message
...
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)