help tweaking my formula ifna match index

pcorpz

Active Member
Joined
Oct 29, 2004
Messages
321
{=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?
 

Some videos you may like

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
Joined
Feb 26, 2019
Messages
766
Office Version
365
Platform
Windows
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
Joined
Oct 29, 2004
Messages
321
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,788
Messages
5,470,786
Members
406,721
Latest member
Laiceyshae

This Week's Hot Topics

Top