Index or match function

=IFERROR(IF(INDEX(Envanter!$W$9:$W$700,SMALL(IF(Envanter!$G$9:$G$700=C$10,ROW($1:$692)),ROW(1:1)))=0,"",INDEX(Envanter!$W$9:$W$700,SMALL(IF(Envanter!$G$9:$G$700=C$10,ROW($1:$692)),ROW(1:1)))),"")

Put in B13 and copied own

Azumi

Originally Posted by azumi

=IFERROR(IF(INDEX(Envanter!$W$9:$W$700,SMALL(IF(Envanter!$G$9:$G$700=C$10,ROW($1:$692)),ROW(1:1)))=0,"",INDEX(Envanter!$W$9:$W$700,SMALL(IF(Envanter!$G$9:$G$700=C$10,ROW($1:$692)),ROW(1:1)))),"")

Put in B13 and copied own

Azumi

Hi Azumi

Thanks for the reply

any chance of hiding empty cells on sheet 1 ın between B13: B700 ....Only dısplay the cell with value

Thanks
Ben