help./

[pierre]

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
????

 

[Peo Sjoblom]

=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]

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

 

[pierre]

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="cc")

THANK YOU

 

[Peo Sjoblom]

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


--


Regards,


Peo Sjoblom