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.