Vlookup returning random numbers

[jamesstorx]

Good Morning,

I have created the attached spreadsheet to be used as a template that would get data pasted into it. The goal is to have the user paste in data in to cells A through G. Then based on that the right hand side of the template (H-L) will calculate how many cases, layers and pallets of product to order based on the figures in the Weight_table. right now it appears that the Vlookup will not find the proper data. Is there a flaw in the way that I have written it? If the weight (Colomn H) is not in the Weight_Table I am ok with "#N/A" being the result, but that is not always happening.

Thanks in advance for any help/insight you can offer

-James

[davegugg]

Set the last argument of the vlookup to 0 (right now you are not using the last argument).

[jamesstorx]

That worked perfect, thanks for your help.