I have an index function that I want to return blanks instead of zeros. There is a Match function in Column T which gives Row number for Index to work. Also.....the values Index return are always text:
=@IF(ISERROR(@INDEX($A$2:$A$30, $T2,1)),"",INDEX($A$2:$A$30,$T2,1))
Bookmarks