####### ?

[bill gras]

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!

 

[Frank Kabel]

Hi
try
=IF(ISERROR(INDEX(...)),"",INDEX(...))

 

[bill gras]

-----Original Message-----
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