Hello again!
Once more I need Your Help. This time again situation is tricky one. I have Item list with Style #, description, sizes and price in one workbook (they are total over 500):
Unknown
<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Style[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Description[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Size[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Price[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]P1111[/TD]
[TD="align: center"]13.95[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]P2222[/TD]
[TD="align: center"]11.95[/TD]
</tbody>
In other workbook I have different information for given item codes:
Unknown
<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Item[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Description[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Barcode[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Style[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Color[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Size[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Box qty[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Buy price[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Sell price[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Sell price inc gst[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #DDEBF7"]P1111 11Z10[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295859[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Green/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]10[/TD]
[TD="bgcolor: #DDEBF7"]75[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]4[/TD]
[TD="bgcolor: #DDEBF7"]P1111 11Z14[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295873[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Green/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]14[/TD]
[TD="bgcolor: #DDEBF7"]65[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #DDEBF7"]P1111 11Z18[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295897[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Green/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]18[/TD]
[TD="bgcolor: #DDEBF7"]60[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]8[/TD]
[TD="bgcolor: #DDEBF7"]P1111 11Z22[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295910[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Green/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]22[/TD]
[TD="bgcolor: #DDEBF7"]50[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]10[/TD]
[TD="bgcolor: #DDEBF7"]P1111 11Z8[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295934[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Green/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]8[/TD]
[TD="bgcolor: #DDEBF7"]80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]11[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]12[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H8112[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295958[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Purple/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]12[/TD]
[TD="bgcolor: #DDEBF7"]70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]14[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H8116[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295972[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Purple/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]16[/TD]
[TD="bgcolor: #DDEBF7"]65[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]16[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H8120[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295996[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Purple/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]20[/TD]
[TD="bgcolor: #DDEBF7"]55[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]17[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]18[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H8124[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042296016[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Purple/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]24[/TD]
[TD="bgcolor: #DDEBF7"]50[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]19[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]20[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H1510[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042296030[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Fluoro Orange/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]10[/TD]
[TD="bgcolor: #DDEBF7"]75[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]21[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]22[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H1514[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042296054[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Fluoro Orange/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]14[/TD]
[TD="bgcolor: #DDEBF7"]65[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]23[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]24[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H1518[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042296078[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Fluoro Orange/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]18[/TD]
[TD="bgcolor: #DDEBF7"]60[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]25[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]26[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H1522[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042296092[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Fluoro Orange/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]22[/TD]
[TD="bgcolor: #DDEBF7"]50[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]27[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]28[/TD]
[TD="bgcolor: #DDEBF7"]P2222 37 10[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275868[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/Red[/TD]
[TD="bgcolor: #DDEBF7, align: right"]10[/TD]
[TD="bgcolor: #DDEBF7"]80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]29[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]30[/TD]
[TD="bgcolor: #DDEBF7"]P2222 37 14[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275882[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/Red[/TD]
[TD="bgcolor: #DDEBF7, align: right"]14[/TD]
[TD="bgcolor: #DDEBF7"]70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]31[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]32[/TD]
[TD="bgcolor: #DDEBF7"]P2222 37 4[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042284341[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/Red[/TD]
[TD="bgcolor: #DDEBF7, align: right"]4[/TD]
[TD="bgcolor: #DDEBF7"]100[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]33[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]34[/TD]
[TD="bgcolor: #DDEBF7"]P2222 37 8[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275912[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/Red[/TD]
[TD="bgcolor: #DDEBF7, align: right"]8[/TD]
[TD="bgcolor: #DDEBF7"]90[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]35[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]36[/TD]
[TD="bgcolor: #DDEBF7"]P2222 91 12[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275936[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/White[/TD]
[TD="bgcolor: #DDEBF7, align: right"]12[/TD]
[TD="bgcolor: #DDEBF7"]80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]37[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]38[/TD]
[TD="bgcolor: #DDEBF7"]P2222 91 16[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275950[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/White[/TD]
[TD="bgcolor: #DDEBF7, align: right"]16[/TD]
[TD="bgcolor: #DDEBF7"]60[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]39[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]40[/TD]
[TD="bgcolor: #DDEBF7"]P2222 91 6[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275967[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/White[/TD]
[TD="bgcolor: #DDEBF7, align: right"]6[/TD]
[TD="bgcolor: #DDEBF7"]45[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]41[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]42[/TD]
[TD="bgcolor: #DDEBF7"]P2222 18J10[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275981[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Grey/Fluroo Lime[/TD]
[TD="bgcolor: #DDEBF7, align: right"]10[/TD]
[TD="bgcolor: #DDEBF7"]80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]43[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]44[/TD]
[TD="bgcolor: #DDEBF7"]P2222 18J14[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042276001[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Grey/Fluoro Lime[/TD]
[TD="bgcolor: #DDEBF7, align: right"]14[/TD]
[TD="bgcolor: #DDEBF7"]70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]45[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]46[/TD]
[TD="bgcolor: #DDEBF7"]P2222 18J4[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042284365[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Grey/Fluoro Lime[/TD]
[TD="bgcolor: #DDEBF7, align: right"]4[/TD]
[TD="bgcolor: #DDEBF7"]100[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]47[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]48[/TD]
[TD="bgcolor: #DDEBF7"]P2222 18J8[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042276032[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Grey/Fluoro Lime[/TD]
[TD="bgcolor: #DDEBF7, align: right"]8[/TD]
[TD="bgcolor: #DDEBF7"]90[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
</tbody>
I need to Index-Match (preferred) or VBA to add all the colors for the given Item Code, preferred result would be:
Unknown
<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Style[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Description[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Size[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Price[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Color[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]P1111[/TD]
[TD="align: center"]13.95[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]P1111[/TD]
[TD="align: center"]13.95[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]P1111[/TD]
[TD="align: center"]13.95[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]P2222[/TD]
[TD="align: center"]11.95[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]P2222[/TD]
[TD="align: center"]11.95[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]P2222[/TD]
[TD="align: center"]11.95[/TD]
</tbody>
OR
Unknown
<tbody>
[TD="align: center"]11[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Style[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Description[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Size[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Price[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Color[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]P1111[/TD]
[TD="align: center"]13.95[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]P2222[/TD]
[TD="align: center"]11.95[/TD]
</tbody>
Unknown
<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Style[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Color[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFFFFF"]P1111[/TD]
[TD="bgcolor: #FFFFFF"]Black/Green/Grey[/TD]
[TD="align: center"]3[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Purple/Grey[/TD]
[TD="align: center"]4[/TD]
[TD="bgcolor: #FFFFFF"]P1111[/TD]
[TD="bgcolor: #FFFFFF"]Black/Fluoro Orange/Grey[/TD]
[TD="align: center"]5[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/Red[/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #FFFFFF"]P2222[/TD]
[TD="bgcolor: #FFFFFF"]Black/White[/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Grey/Fluoro Lime[/TD]
</tbody>
Maybe it makes task easier?
Honestly, I don't have a clue what to do in this case, so hopefully someone will be able to help. Very much appreciated would be also explanations for formulas or VBA codes, so I can adjust and change it in the future. My goal isn't just to get problem solved, but I want to learn something, so I next time I know what to do.
I really hope that someone will be able to help me with this one. Thank You very much!
Sincerely,
Tony
Once more I need Your Help. This time again situation is tricky one. I have Item list with Style #, description, sizes and price in one workbook (they are total over 500):
Unknown
| A | B | C | D | |
|---|---|---|---|---|
| Ladies Polo | 8|10|12|14|16|18|20|22|24 | |||
| Kids Polo | 4|6|8|10|12|14|16 |
<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Style[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Description[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Size[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Price[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]P1111[/TD]
[TD="align: center"]13.95[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]P2222[/TD]
[TD="align: center"]11.95[/TD]
</tbody>
Sheet1
In other workbook I have different information for given item codes:
Unknown
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| P1111 11Z12 | Ladies Polo | 9401042295866 | P1111 | Black/Green/Grey | 70 | |||||
| P1111 11Z16 | Ladies Polo | 9401042295880 | P1111 | Black/Green/Grey | 65 | |||||
| P1111 11Z20 | Ladies Polo | 9401042295903 | P1111 | Black/Green/Grey | 55 | |||||
| P1111 11Z24 | Ladies Polo | 9401042295927 | P1111 | Black/Green/Grey | 50 | |||||
| P1111 H8110 | Ladies Polo | 9401042295941 | P1111 | Black/Purple/Grey | 75 | |||||
| P1111 H8114 | Ladies Polo | 9401042295965 | P1111 | Black/Purple/Grey | 65 | |||||
| P1111 H8118 | Ladies Polo | 9401042295989 | P1111 | Black/Purple/Grey | 60 | |||||
| P1111 H8122 | Ladies Polo | 9401042296009 | P1111 | Black/Purple/Grey | 50 | |||||
| P1111 H818 | Ladies Polo | 9401042296023 | P1111 | Black/Purple/Grey | 80 | |||||
| P1111 H1512 | Ladies Polo | 9401042296047 | P1111 | Black/Fluoro Orange/Grey | 70 | |||||
| P1111 H1516 | Ladies Polo | 9401042296061 | P1111 | Black/Fluoro Orange/Grey | 65 | |||||
| P1111 H1520 | Ladies Polo | 9401042296085 | P1111 | Black/Fluoro Orange/Grey | 55 | |||||
| P1111 H1524 | Ladies Polo | 9401042296108 | P1111 | Black/Fluoro Orange/Grey | 50 | |||||
| P2222 37 12 | Kids Polo | 9401042275875 | P2222 | Black/Red | 80 | |||||
| P2222 37 16 | Kids Polo | 9401042275899 | P2222 | Black/Red | 60 | |||||
| P2222 37 6 | Kids Polo | 9401042275905 | P2222 | Black/Red | 90 | |||||
| P2222 91 10 | Kids Polo | 9401042275929 | P2222 | Black/White | 80 | |||||
| P2222 91 14 | Kids Polo | 9401042275943 | P2222 | Black/White | 70 | |||||
| P2222 91 4 | Kids Polo | 9401042284358 | P2222 | Black/White | 50 | |||||
| P2222 91 8 | Kids Polo | 9401042275974 | P2222 | Black/White | 90 | |||||
| P2222 18J12 | Kids Polo | 9401042275998 | P2222 | Grey/Fluoro Lime | 80 | |||||
| P2222 18J16 | Kids Polo | 9401042276018 | P2222 | Grey/Fluoro Lime | 60 | |||||
| P2222 18J6 | Kids Polo | 9401042276025 | P2222 | Grey/Fluoro Lime | 90 | |||||
<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Item[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Description[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Barcode[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Style[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Color[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Size[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Box qty[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Buy price[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Sell price[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Sell price inc gst[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #DDEBF7"]P1111 11Z10[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295859[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Green/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]10[/TD]
[TD="bgcolor: #DDEBF7"]75[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]4[/TD]
[TD="bgcolor: #DDEBF7"]P1111 11Z14[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295873[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Green/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]14[/TD]
[TD="bgcolor: #DDEBF7"]65[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #DDEBF7"]P1111 11Z18[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295897[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Green/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]18[/TD]
[TD="bgcolor: #DDEBF7"]60[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]8[/TD]
[TD="bgcolor: #DDEBF7"]P1111 11Z22[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295910[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Green/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]22[/TD]
[TD="bgcolor: #DDEBF7"]50[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]10[/TD]
[TD="bgcolor: #DDEBF7"]P1111 11Z8[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295934[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Green/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]8[/TD]
[TD="bgcolor: #DDEBF7"]80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]11[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]12[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H8112[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295958[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Purple/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]12[/TD]
[TD="bgcolor: #DDEBF7"]70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]14[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H8116[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295972[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Purple/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]16[/TD]
[TD="bgcolor: #DDEBF7"]65[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]16[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H8120[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042295996[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Purple/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]20[/TD]
[TD="bgcolor: #DDEBF7"]55[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]17[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]18[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H8124[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042296016[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Purple/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]24[/TD]
[TD="bgcolor: #DDEBF7"]50[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]19[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]20[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H1510[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042296030[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Fluoro Orange/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]10[/TD]
[TD="bgcolor: #DDEBF7"]75[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]21[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]22[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H1514[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042296054[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Fluoro Orange/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]14[/TD]
[TD="bgcolor: #DDEBF7"]65[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]23[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]24[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H1518[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042296078[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Fluoro Orange/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]18[/TD]
[TD="bgcolor: #DDEBF7"]60[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]25[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]26[/TD]
[TD="bgcolor: #DDEBF7"]P1111 H1522[/TD]
[TD="bgcolor: #DDEBF7"]Ladies Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042296092[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Fluoro Orange/Grey[/TD]
[TD="bgcolor: #DDEBF7, align: right"]22[/TD]
[TD="bgcolor: #DDEBF7"]50[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$22.42[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$38.85[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$46.62[/TD]
[TD="align: center"]27[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]$22.42[/TD]
[TD="align: right"]$38.85[/TD]
[TD="align: right"]$46.62[/TD]
[TD="align: center"]28[/TD]
[TD="bgcolor: #DDEBF7"]P2222 37 10[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275868[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/Red[/TD]
[TD="bgcolor: #DDEBF7, align: right"]10[/TD]
[TD="bgcolor: #DDEBF7"]80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]29[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]30[/TD]
[TD="bgcolor: #DDEBF7"]P2222 37 14[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275882[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/Red[/TD]
[TD="bgcolor: #DDEBF7, align: right"]14[/TD]
[TD="bgcolor: #DDEBF7"]70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]31[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]32[/TD]
[TD="bgcolor: #DDEBF7"]P2222 37 4[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042284341[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/Red[/TD]
[TD="bgcolor: #DDEBF7, align: right"]4[/TD]
[TD="bgcolor: #DDEBF7"]100[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]33[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]34[/TD]
[TD="bgcolor: #DDEBF7"]P2222 37 8[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275912[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/Red[/TD]
[TD="bgcolor: #DDEBF7, align: right"]8[/TD]
[TD="bgcolor: #DDEBF7"]90[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]35[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]36[/TD]
[TD="bgcolor: #DDEBF7"]P2222 91 12[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275936[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/White[/TD]
[TD="bgcolor: #DDEBF7, align: right"]12[/TD]
[TD="bgcolor: #DDEBF7"]80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]37[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]38[/TD]
[TD="bgcolor: #DDEBF7"]P2222 91 16[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275950[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/White[/TD]
[TD="bgcolor: #DDEBF7, align: right"]16[/TD]
[TD="bgcolor: #DDEBF7"]60[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]39[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]40[/TD]
[TD="bgcolor: #DDEBF7"]P2222 91 6[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275967[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/White[/TD]
[TD="bgcolor: #DDEBF7, align: right"]6[/TD]
[TD="bgcolor: #DDEBF7"]45[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]41[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]42[/TD]
[TD="bgcolor: #DDEBF7"]P2222 18J10[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042275981[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Grey/Fluroo Lime[/TD]
[TD="bgcolor: #DDEBF7, align: right"]10[/TD]
[TD="bgcolor: #DDEBF7"]80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]43[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]44[/TD]
[TD="bgcolor: #DDEBF7"]P2222 18J14[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042276001[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Grey/Fluoro Lime[/TD]
[TD="bgcolor: #DDEBF7, align: right"]14[/TD]
[TD="bgcolor: #DDEBF7"]70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]45[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]46[/TD]
[TD="bgcolor: #DDEBF7"]P2222 18J4[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042284365[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Grey/Fluoro Lime[/TD]
[TD="bgcolor: #DDEBF7, align: right"]4[/TD]
[TD="bgcolor: #DDEBF7"]100[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
[TD="align: center"]47[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]$17.70[/TD]
[TD="align: right"]$51.80[/TD]
[TD="align: right"]$34.19[/TD]
[TD="align: center"]48[/TD]
[TD="bgcolor: #DDEBF7"]P2222 18J8[/TD]
[TD="bgcolor: #DDEBF7"]Kids Polo[/TD]
[TD="bgcolor: #DDEBF7"]9401042276032[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Grey/Fluoro Lime[/TD]
[TD="bgcolor: #DDEBF7, align: right"]8[/TD]
[TD="bgcolor: #DDEBF7"]90[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$17.70[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$51.80[/TD]
[TD="bgcolor: #DDEBF7, align: right"]$34.19[/TD]
</tbody>
Sheet2
I need to Index-Match (preferred) or VBA to add all the colors for the given Item Code, preferred result would be:
Unknown
| A | B | C | D | E | |
|---|---|---|---|---|---|
| Ladies Polo | 8|10|12|14|16|18|20|22|24 | Black/Green/Grey | |||
| Ladies Polo | 8|10|12|14|16|18|20|22|24 | Black/Purple/Grey | |||
| Ladies Polo | 8|10|12|14|16|18|20|22|24 | Black/Fluoro Orange/Grey | |||
| Kids Polo | 4|6|8|10|12|14|16 | Black/Red | |||
| Kids Polo | 4|6|8|10|12|14|16 | Black/White | |||
| Kids Polo | 4|6|8|10|12|14|16 | Grey/Fluoro Lime |
<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Style[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Description[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Size[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Price[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Color[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]P1111[/TD]
[TD="align: center"]13.95[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]P1111[/TD]
[TD="align: center"]13.95[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]P1111[/TD]
[TD="align: center"]13.95[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]P2222[/TD]
[TD="align: center"]11.95[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]P2222[/TD]
[TD="align: center"]11.95[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]P2222[/TD]
[TD="align: center"]11.95[/TD]
</tbody>
Sheet3
OR
Unknown
| A | B | C | D | E | |
|---|---|---|---|---|---|
| Ladies Polo | 8|10|12|14|16|18|20|22|24 | Black/Green/Grey|Black/Purple/Grey|Black/Fluoro Orange/Grey | |||
| Kids Polo | 4|6|8|10|12|14|16 | Black/Red|Black/White|Grey/Fluoro Lime |
<tbody>
[TD="align: center"]11[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Style[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Description[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Size[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Price[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Color[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]P1111[/TD]
[TD="align: center"]13.95[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]P2222[/TD]
[TD="align: center"]11.95[/TD]
</tbody>
Sheet3
Index-match is preferred because, I don't know VBA and for me would be much easier to make some adjustments in the future and learn how to use it. Maybe some of You thinks - let's get not only color information, but also all sizes for given color and with it also Barcodes, but it's not possible in this case, because first file is newest one (reference) and in it could be changed sizes for given items, so after color I will separate sizes and based on it receive other information (that's not a problem), but main thing is to get colors. One of my thought how to make, maybe, it easier would be to make another sheet and keep on it Style number and each color 1 time: Unknown
| A | B | |
|---|---|---|
<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Style[/TD]
[TD="bgcolor: #BDD7EE, align: center"]Color[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFFFFF"]P1111[/TD]
[TD="bgcolor: #FFFFFF"]Black/Green/Grey[/TD]
[TD="align: center"]3[/TD]
[TD="bgcolor: #DDEBF7"]P1111[/TD]
[TD="bgcolor: #DDEBF7"]Black/Purple/Grey[/TD]
[TD="align: center"]4[/TD]
[TD="bgcolor: #FFFFFF"]P1111[/TD]
[TD="bgcolor: #FFFFFF"]Black/Fluoro Orange/Grey[/TD]
[TD="align: center"]5[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Black/Red[/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #FFFFFF"]P2222[/TD]
[TD="bgcolor: #FFFFFF"]Black/White[/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #DDEBF7"]P2222[/TD]
[TD="bgcolor: #DDEBF7"]Grey/Fluoro Lime[/TD]
</tbody>
Sheet2 (2)
Maybe it makes task easier?
Honestly, I don't have a clue what to do in this case, so hopefully someone will be able to help. Very much appreciated would be also explanations for formulas or VBA codes, so I can adjust and change it in the future. My goal isn't just to get problem solved, but I want to learn something, so I next time I know what to do.
I really hope that someone will be able to help me with this one. Thank You very much!
Sincerely,
Tony
