please help
I have a array formula as follows
=INDEX(st5!$C$1:$C$1800,SMALL(IF(st5!$A$1:$A$1800 =D4,ROW
(st5!$A$1:$A$1800)),ROW(st5!$1:$1)))
when there is no value in the cell it returns ##### is
there a way that this can be fixed so a blank cell can be
seen?
thanking you all!
.
sory frank your formula did not work
can you please try again
thank you
..