vlookup for multiple unique values?

Hello all,

i'm wondering if there is a formula that can be created for the below that will show the unqiue number of carton per each product # & size code. for example see below. I would like a formula to read off the chart to fill in shipping carton #1 & #2. i filled carton in this example but i would like a formula to generate this from a list. would this be possible?

also note there will be multiple product #'s, size codes and shipping cartons.

I was using the formula below but it will include all cartons including duplicates. please excuse the data ranges.

=INDEX('MV Inv'!$T$4:$T$65536, SMALL(IF(D$3&K$3&N$3='MV Inv'!$B$4:$B$65536, ROW('MV Inv'!$B$4:$B$65536)-ROW('MV Inv'!C4)+1), ROW(1:1)))

Thank you excel community.

Steven

Product # Size code Shipping carton Shipping Carton #1 Shipping Carton #2
100100 10 A100 A100 A200
100100 10 A100
100100 10 A100
100100 10 A100
100100 10 A100
100100 10 A200
100100 10 A200
100100 10 A200
100100 10 A200
100100 10 A200

I think so. If you post a workbook with some sample data it will be much easier to help you.

Not sure, do you mean like the result in this Pivot Table?

i think technically i can add a column and just add product cd with size cd and lookup to that value with your formula and it should work..

also, just another thought but if the shipping carton wasn't in increasing order the formula should still work?