Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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) |