hello....please help me on this one :
i have the following correct formula :

=INDEX(B$1:B$7,SMALL(IF(($A$1:$A$7=$G$1)+($A$1:$A$ 7=$G$2)+($A$1:$A$7=$G$3),ROW(B$1:B$7)),ROWS(B$1:B1 )))

is there any way to make THIS part :
if(($A$1:$A$7=$G$1)+($A$1:$A$7=$G$2)+($A$1:$A$7=$G $3) in a way to be SHORTER
????

=INDEX(B$1:B$7,SMALL(IF(($A$1:$A$7=TRANSPOSE($G$1: $G$3)),ROW(B$1:B$7)),ROWS(B$1:B1)))


Array entered


--


Regards,


Peo Sjoblom




"pierre" wrote in message
...
hello....please help me on this one :
i have the following correct formula :

=INDEX(B$1:B$7,SMALL(IF(($A$1:$A$7=$G$1)+($A$1:$A$ 7=$G$2)+($A$1:$A$7=$G$3),ROW(B$1:B$7)),ROWS(B$1:B1 )))

is there any way to make THIS part :
if(($A$1:$A$7=$G$1)+($A$1:$A$7=$G$2)+($A$1:$A$7=$G $3) in a way to be
SHORTER
????

THANK YOU VERY MUCH.......it worked smoothly.......
thankxxx ;)

please one more little thing :(related to my precedent issue)
how to resolve this equation in a shorter way ??
if(($A$1:$A$7="aa")+($A$1:$A$7="bb")+($A$1:$A$7="c c")

THANK YOU

($A$1:$A$7={"aa","bb","cc"})


--


Regards,


Peo Sjoblom


"pierre" wrote in message
...
please one more little thing :(related to my precedent issue)
how to resolve this equation in a shorter way ??
if(($A$1:$A$7="aa")+($A$1:$A$7="bb")+($A$1:$A$7="c c")

THANK YOU