help tweaking my formula ifna match index

[pcorpz]

{=IFNA(INDEX(PO[Price],MATCH([@[SO Date]]&[@[User Name]]&[@[Item No.]]&[@[SO Qty]],PO[Posting Date]&PO[User Name]&PO[Item No.]&PO[Quantity],0)),INDEX(PO[Price],MATCH([@[Item No.]]&[@[Cost Exact Match]],PO[Item No.]&PO[Sales Exact Match],0)))}

My formula works but I know it should be written differently! I know why I'm still getting #n/a -- my problem is how or where do I include it in the formula to show as zero?

 

[tyija1995]

If you just want #N/A! to show as 0 then use =IFNA at the start, put that formula above inside the first parameter, and then the 2nd parameter put a 0.

 

[pcorpz]

If you just want #N/A! to show as 0 then use =IFNA at the start, put that formula above inside the first parameter, and then the 2nd parameter put a 0.

Thanks for the reply, tyija. Not sure I follow.. could you perhaps rewrite the formula I provided? I already have =ifna as the start.