Do not return a zero value with index function

[Tmoske]

I am using the following formula to extract the data I need for a chart

=INDEX(AF$16:AF$38,$A$2)

How can I have this formula not return a zero value if the cell it's referring to is blank?

It is plotting the zero for a data point in my chart. I have the chart set on "show empty cells as" Gaps". It doesn't matter that I have changed the excel options to not show zero values either.

Please help,
Tmoske

 

[andyreloaded]

=IF(ISBLANK(INDEX(AF$16:AF$38,$A$2)),"",INDEX(AF$16:AF$38,$A$2))

Not sure if it will work for you, but it might.