Formula to add total qty in multiples of minimum pack sizes

[RJSIGKITS]

Okay, So I'm trying to set a supplier order form to specify the minimum order quantity of items specified by minimum pack sizes based on quantity of items ordered on a separate quote sheet...
so Far, I have this:
<d18,d18,(vlookup(a18,quotetable,5,0)))

=IF(VLOOKUP(A18,QUOTETABLE,5,0) < D18,D18,(VLOOKUP(A18,QUOTETABLE,5,0)))

** Remove the spaces before and after < due to forum issues **
QuoteTable is where the salesperson adds the product code and quantity the client wants to the order, and this code is going on the supplier order sheet where I need the total of items i need to order dependant on the minimum pack sizes. I need it to calculate the supplier order based on total quoted, and total of items by minimum pack size order quantity.
EG, if the minimum pack size is 2, and the client wants 3, I have to order 4, and so the cell on the order form needs to automatically work out that I need to order 4...

Hoping someone can help!

**Please note** I have posted this previously, but was having difficulty with the forum cropping my code, so the post is confusing. I decided it best to start from scratch.</d18,d18,(vlookup(a18,quotetable,5,0)))

 

[FormR]

Hi - is cell D18 the product pack size?

If so maybe:

=CEILING(VLOOKUP(A18,quotetable,5,0),D18)

 

[RJSIGKITS]

Hi - is cell D18 the product pack size?

If so maybe:

=CEILING(VLOOKUP(A18,quotetable,5,0),D18)

Hey! Thanks, that's a great start as it does do what I asked. It does, however, give me '#N/A' on the items that have not been quoted - so I need to add an IF Statement that tells it to display nothing if nothing is found.. I'm trying this, but still getting the #N/A:

=IF(VLOOKUP(A18,QUOTETABLE,5,0)="",0,CEILING(VLOOKUP(A18,QUOTETABLE,5,0),D18))

 

[FormR]

You could try:

=IFERROR(CEILING(VLOOKUP(A18,quotetable,5,0),D18),0)

 

[RJSIGKITS]

Hey! Thanks, that's a great start as it does do what I asked. It does, however, give me '#N/A' on the items that have not been quoted - so I need to add an IF Statement that tells it to display nothing if nothing is found.. I'm trying this, but still getting the #N/A:

=IF(VLOOKUP(A18,QUOTETABLE,5,0)="",0,CEILING(VLOOKUP(A18,QUOTETABLE,5,0),D18))

got it!

=IFERROR(CEILING(VLOOKUP(A18,QUOTETABLE,5,0),D18),0)

Thanks for your help!