Indexing blank cells as blank

[Mr.WalterJones]

I am trying to use the INDEX function. However, certain cells are blank and when indexed return zeroes. Is there anyway I can have it return a blank cell?

Thank you!

[rvasquez]

This should do it!

=IF(INDEX(range,row,column)=0,"",INDEX(range,row,column))

Thanks!

[tigeravatar]

Mr.WalterJones,

There are many ways you can do that. Three suggestions are:

1) Use a custom format to make 0's show as blanks. To do so, select the range of Index Results -> Right-click and select Format Cells -> Custom -> Type "0; ; " (no quotes, that's Zero Semicolon Space Semicolon Space) -> OK

2) Use conditional formatting to make 0's show as blanks. To do so, select the range of Index Results -> Conditional Formatting -> Highlight Cells Rules -> Equal To... -> Type 0 and select Custom Format from the dropdown list -> Go tot he Number tab -> Custom -> Type "0; ; " (no quotes) -> OK

3) Incorporate a check into the formula.
=IF(INDEX(A1:A10,3)=0,"",INDEX(A1:A10,3))

[Mr.WalterJones]

YOU GUYS ARE THE BEST!

TIGER YOU ARE A G, THAT'S A G FOR GANGSTA! Thank you very much!