How to set a vlookup with missing numbers

[SugarCube]

I have a spreadsheet that lists all of the items I need to order. They are in numerical order but some items are not needed so they are not in the range for the vlookup (picture 1). #1051 is missing. Since #1051 is missing, it duplicates the amount in #1050 (picture 2). I get that it has no info to pull from for #1051 - I need to see how to make #1051 show as 0. I have tried to google some info, maybe adding a CountIf or some other function but I can't figure it out. Any help is appreciated! (New to this site. Hoping pictures attached )

 

[Joe4]

Welcome to the Board!

It sounds like you have the last argument of your VLOOKUP set to TRUE, which tells Excel that if it cannot find a match, select the value from the closest one less than that.
If you set that argument to FALSE, it with return a #N/A error, indicating no match. If you surround that in an IFERROR statement, you can tell it to return 0 instead of that error code, i.e.

=IFERROR(VLOOKUP([I]arg1,arg2,arg3[/I],FALSE),0)

 

[SugarCube]

Thank you Joe4!!! Actually I didn't have it as True or False. I did have the IfError already in there and couldn't see why it wasn't giving me a 0. I updated the formula to False and BAM! It worked!!! Thank you!!

 

[Joe4]

Actually I didn't have it as True or False.

Yep, if you omit that 4th argument, it defaults to TRUE. You need to explicitly enter a FALSE (or 0) if you want it to be false.

Glad it worked for you!