Thread: Change #n/a value to 0 when using INDEX and MATCH fonction

Hello Everyone ,

I have been trying to figure out how to get rid of this evil #n/a value, in my formula,

Here is the formula I am using : =INDEX(Automate_Pricing!C4:G13,MATCH(PLAN.ECO!R10,Automate_Pricing!B4:B13,0),MATCH(PLAN.ECO!V10,Auto mate_Pricing!C3:G3,0))

to be a little bit more specific

R10 is a model
V10 is a code number going from 1 to 5

So let's say I have 3 models :

Model A
Model B
Model C

And also 3 different codes :

Code 1
Code 2
Code 3

This formula is use to determine the price of a model depending on it's code .

Model A - Code 1 = 10$
Model A - Code 2 = 20$

Etc...

This formula is used for a rental project , my problem is that we offer several different models although only part of them are up for rental,
so when you choose a model that is available on our inventory , but not available for rent , I get the error #n/a and then it won't let me SUM up .

Can someone help me !

Thank you very much

Hello,

Use IFERROR

=IFERROR(YourFormula,0)

Will show as 0 if the output is error, otherwise it's value.