Index and Match return 0.00 when the reference is empty

[habids]

hi,
In "moderation" sheet I try index and match from $N$10:$N$18 marks to Y10:Y25 but if $N$10:$N$18
is empty it returns 0.00 instead of empty ("").
Formula in Y10: =IFERROR(INDEX($N$10:$N$18,MATCH(V12,$C$10:$C$18,0)),"")
I need help from my friend here. Thank you very much.

Visual Explanation in sheets "Explanation"

sample files

[HansDouwe]

One way: Custom format your cells as: "0.00;;".

Now the zeros are invisible, because after the second semicolon is nothing.

[BadlySpelledBuoy]

I agree with the solution proposed by Hans above, however, hiding the zero result with formatting could have repercussions with other formulas (averages based on those cells etc.).
You could use the formula below.

Please Login or Register  to view this content.

BSB

[Glenn Kennedy]

If you are returning NUMBERS, you can also use:

=IFERROR(1/(1/INDEX($N$10:$N$18,MATCH(V12,$C$10:$C$18,0))),"")

or if TEXT:

=IFERROR(INDEX($N$10:$N$18,MATCH(V12,$C$10:$C$18,0))&"","")

[habids]

Thank you very much to BadlySpelledBuoy and Glenn Kennedy. Both of the formula (Function) run smoothly. I am try several days but you just a few minute or may be a few second. One again thank you very much.

[BadlySpelledBuoy]

It's only easy when you know how

BSB

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.