If and Vlookup Formula

[Cleman04]

I'm trying to get a cell {in the attached spreadsheet 'Order Form' Sheet- Cell 'B13'}, to bring up the corresponding product description {'Products' Sheet- Column C}. For the cell that is to bring up the product description {'Order Form' Sheet- Cell 'C13'}, the following is the formula I'm trying to use, but is coming up "#N/A":
=IF(C13>1000,VLOOKUP(A13,Products!$A$2:$D$12,3),IF(C13>287,VLOOKUP(A13,Products!$A$14:$D$25,3),IF(C13>0,VLOOKUP(A13,Products!$A$28:$D$38,3)," "))).

I could also use some assistance determining the appropriate formula to pull up the correct corresponding cost/bottle. I haven't attempted the "Cost/Bottle" formula yet {'Order Form' Sheet- Cell 'D13'}, but it needs to correspond the product number {'Order Form' Sheet- Cell 'A13'} and the quantity ordered {'Order Form' Sheet- Cell 'C13'}, with the cost/bottle on the that quantity found on 'Products' Sheet, Column D.

Thank you.

[Cleman04]

Sorry, I didn't have the formula plugged into the attachment file as I mentioned in the last post- This attachment contains the formula that is giving me the "#N/A".

[martindwilson]

Products!$A$28:$D$38 has nothing in it!
also doesnt exist
103CL or 165CL
on products sheet
and now i notice
it links to
Chile -New Template where's that then?

[Cleman04]

I deleted the links now. I'm still having problems getting these formulas to return the correct product description and price. Could you again review this attachment and give me your input?

[martindwilson]

b13 should be
=IF(C13>1000,VLOOKUP(A13,Products!$A$2:$D$8,3,FALSE),IF(C13>287,VLOOKUP(A13,Products!$A$10:$D$16,3,FALSE),IF(C13>0,VLOOKUP(A13,Products!$A$19:$D$25,3,FALSE)," ")))
d13 should be
=IF(C13>1000,VLOOKUP(A13,Products!$A$2:$D$8,4,FALSE),IF(C13>287,VLOOKUP(A13,Products!$A$10:$D$16,4,FALSE),IF(C13>0,VLOOKUP(A13,Products!$A$19:$D$25,4,FALSE)," ")))

[Cleman04]

Thank you for your help!