This array formula returns a cell value but not if it's a number. Is it possible to return a cell value as a number or text?

Thank you!

Russ

=IFERROR(INDEX(Distro!$Z$1:Distro!$Z$3244,SMALL(IF(ISTEXT(Distro!$Z$1:Distro!$Z$3244),ROW(Distro!$Z$1:Distro!$Z$3244),""),ROW(Distro!Z1))),"")