# help tweaking my formula ifna match index

#### pcorpz

##### Active Member
{=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?

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### tyija1995

##### Well-known Member
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

##### Active Member
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.