#N/A when using a IF Statement and Index Match

[ceytl]

If I don't have a the correct value in D32:D45 using formula =IF(AND(A25="2020D",F25+INDEX($C$32:$C$45,MATCH(A25,$D$32:$D$45,0))>=6),6-2,F25) it comes back #N/A.

How do I fix the #N/A

I'm thinking I need to have it return 0 if no value and then it can add to cell F25.

Thanks!

Test.xlsx
	A	B	C	D	E	F	G
23	Part No.	Description	Code	Retail	Cost	Order Qty	Ship Qty
24	2020D	Airplane	AZ	$2,000.00	$850.00	5	4
25	2020Z	Airplane	AZ	$2,000.00	$850.00	2	#N/A
26
27
28
29
30
31			QTY	Part#
32			2	2020D
33			2
34
35
36
37
38
39
40
41
42
43
44
45
Sheet1

Cell Formulas
Range	Formula
G24:G25	G24	=IF(AND(A24="2020D",F24+INDEX($C$32:$C$45,MATCH(A24,$D$32:$D$45,0))>=6),6-2,F24)

 

[sandy666]

maybe

=IFNA(your_formula, 0)

 

[ceytl]

maybe IFNA(your_formula, 0

It worked! Thank you!

 

[sandy666]

You are welcome & thanks for the feedback

btw. you marked as solution your own post which is not true in this case

 

[smozgur]

It worked! Thank you!

@ceytl - Although we closely monitor and moderate the marked solutions, in your future questions, please mark the solution which answers your question instead of your own post - unless you found and posted your own solution. This way, it will help future visitors who might have the same question. In fact, you might also consider revisiting your old questions and mark the solution posts to help future visitors. You can find the list of your old questions by using the following link:

Excel Questions

All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. Do not post questions about other spreadsheet programs (e.g. Google Sheets) in this forum.

www.mrexcel.com

As I mentioned, we are already moderating the marked solutions. Therefore, I already switched the marked solution as necessary in this thread. There is no further action to do on this question.