Taking out the DIV and N/A Errors in a Vlook up

[exeldc]

Hello Forum

Just took on a new workbook and noticed that the person before did not build their formulas for DIV and NA errors.

How can I adjust the following formula to have these areas turn to "0" instead of the errors. Thank you

=VLOOKUP($J$1,Today_FOOD,10,FALSE)/VLOOKUP($J$1,Today_FOOD,9,FALSE)
=(VLOOKUP($C8,Today_FOOD,37,FALSE))/(VLOOKUP($C8,Today_FOOD,36,FALSE))
=VLOOKUP($C15,Today_FOOD,17,FALSE)

 

[OFFICE360]

Try using IFERROR or If(ISNA to handle the error.
Example=IFERROR(VLOOKUP($J$1,Today_FOOD,10,FALSE)/VLOOKUP($J$1,Today_FOOD,9,FALSE),0)

 

[exeldc]

Ok those worked!

What about =(VLOOKUP($J$1,Today_FOOD,37,FALSE)/VLOOKUP($J$1,Today_FOOD,36,FALSE))-(VLOOKUP($J$1,Yesterday_FOOD,37,FALSE)/VLOOKUP($J$1,Yesterday_FOOD,36,FALSE))

 

[OFFICE360]

I think you should add handlers for each of them or maybe change formula because any of those formula error will trigger IFERROR.

In short
=IFERROR((VLOOKUP($J$1,Today_FOOD,37,FALSE)/VLOOKUP($J$1,Today_FOOD,36,FALSE))-(VLOOKUP($J$1,Yesterday_FOOD,37,FALSE)/VLOOKUP($J$1,Yesterday_FOOD,36,FALSE)),"Error")

I cannot confirm the formula for you because my office is under re-installations...

 

[exeldc]

Also I tried changing the formula below =(VLOOKUP($C8,Today_FOOD,37,FALSE))/(VLOOKUP($C8,Today_FOOD,36,FALSE))

to =IFERROR(VLOOKUP($C8,Today_FOOD,37,FALSE))/(VLOOKUP($C8,Today_FOOD,36,FALSE),0) but got a message saying Ive entered too few arguments

 

[OFFICE360]

check for missing brackets

=IFERROR((VLOOKUP($C8,Today_FOOD,37,FALSE))/(VLOOKUP($C8,Today_FOOD,36,FALSE)),0)

 

[exeldc]

Yeah also tried =IFERROR((VLOOKUP($J$1,Today_FOOD,37,FALSE)/VLOOKUP($J$1,Today_FOOD,36,FALSE))-(VLOOKUP($J$1,Yesterday_FOOD,37,FALSE)/VLOOKUP($J$1,Yesterday_FOOD,36,FALSE)),"Error") but got the error