-----Original Message-----
please help
I have a array formula as follows
=INDEX(st5!$C$1:$C$1800,SMALL(IF(st5!$A$1:$A$180 0=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
=IF(ISERROR(INDEX(...)),"",INDEX(...)) (sorry i left your
formula out)
can you please try again
thank you
..


.