INDEX command returns a value of #NA if no values

[Kap61]

Trying to look up multiple values in an index if they are greater than zero, can get everything to work until I run out of values, then I get #NA . Need Zero value if not available so other formulas in cells referencing the value do not return an error.

Formula used is below, bold numbers are changed between 0 and 6 for my worksheet to lookup the next available value greater than zero.
Data is in column D

"=INDEX(INDEX(D3:D15,MATCH(TRUE,INDEX(D3:D15<>0,),0)+2):D15,MATCH(TRUE,INDEX(INDEX(D3:D15,MATCH(TRUE,INDEX(D3:D15<>0,),0)+2):D15<>0,),0))"

 

[Eric W]

Try:

=IFERROR(INDEX(...),0)

 

[Kap61]

Just what I needed, now with conditional formatting my 0 value turns white and nobody knows it is there!

 

[Eric W]

Glad it works for you!