Need 0 Value Returned for NA# on Index Match Formula

I've looked at quite a few threads and haven't been able to find a working solution.

I'm searching two sheets for a value, and on occasion the value will not be present so I am met with #N/A. I want to replace the #N/A with a 0.

My formula is:

=IF($C178="","",INDEX('1530T'!K:K,MATCH($C178,'1530T'!$B:$B,0)))

If I try:

=IFNA(($C178="","",INDEX('1530T'!K:K,MATCH($C178,'1530T'!$B:$B,0))),"0")

It doesnt seem to work.

Probably missing something very obvious here, any help is appreciated.

I'm not totally sure if you're working with number results or letters, but you might try this:

Start your code with this:

"{=IF(ISBLANK(RESULT CELL),"",INDEX(...}"

This will return "0" instead of "N/A".

Hope this helps.