Thread: ??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pierre Pierre is offline
external usenet poster
 
Posts: 149
Default ??

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)