Spreadsheet: 41326d1239804879-lookup-from-two-arrays-679812_tawfiq
Sheet: Sheet1

Item ID | Color | Sum of Total Units Sold
205059 | BLACK | 3
205060 | BLACK | 1
205062 | TAUPE | 0
205063 | BLACK | 1
 | TAUPE | 1
205064 | BLACK | 3
205065 | BLACK | 4
 | BROWN | 4
205066 | BLACK | 3
205069 | BLACK | 3
205070 | BLACK | 3
205072 | BLACK | 4
353008 | BLUE | 4
353009 | CREAM | 3
364298 | BLACK | 0
 | GREY | 0
364299 | BLACK | 2
364300 | BROWN | 2
364302 | PINK | 2
364303 | BLACK | 1
364304 | CREAM | 1
 | TAUPE | 1
364307 | BLACK | 4
364308 | BLACK | 4
364312 | BLACK | 5
364313 | WHITE | 1
364314 | BLACK | 5
364315 | BLACK | 1
364318 | GREY | 0
 | PINK | 0
364319 | GREEN | 2
364320 | BLACK | 3
364321 | BLACK | 5
364323 | BLACK | 5
364324 | BLACK | 2
 | RED | 2
365176 | GREY | 0
 | WHITE | 0
365177 | DARK-BROWN | 10
365182 | CREAM | 1
365183 | CREAM | 1
365184 | BLACK | 3
 | NUDE | 3
365186 | BLACK | 2
 | ORANGE | 2
365188 | BLACK | 3
365189 | BLACK | 2
365190 | BLACK | 3
 | DARK-BROWN | 3
365191 | BLACK | 1
365192 | NUDE | 3
374189 | TAN | 1
374191 | BLACK | 0
 | GREY | 0
 | WHITE | 0
374194 | OLIVE | 0
 | WHITE | 0
374197 | BROWN | 2
374199 | BEIGE | 0
 | BLUE | 0
 | BROWN | 0
374200 | FUSCHIA | 2
 | YELLOW | 2
374201 | TAUPE | 1
374202 | BROWN | 0
 | CREAM | 0
 | TAUPE | 0
374203 | BLACK | 0
374205 | BROWN | 3
374207 | BLACK | 5
374208 | BLACK | 1
374209 | BEIGE | 2
 | BLACK | 2
374210 | BLACK | 2
374211 | BROWN | 0
 | GREY | 0
374213 | BLACK | 1
 | NUDE | 1
374214 | BLACK | 1
374235 | BLACK | 2
 | WHITE | 2
448013 | BLACK | 1
536015 | BLACK | 0
 | BROWN | 0
 | WHITE | 0
536017 | BLACK | 0
 | WHITE | 0
538027 | BLACK | 0
 | BROWN | 0
 | PINK | 0
538028 | BLACK | 2
601118 | GREY | 2
 | NUDE | 2
601119 | BLACK | 2
 | CREAM | 2
601122 | BLACK | 3
601123 | BLACK | 3
605288 | BLACK | 1
 | GREY | 1
 | WHITE | 1
605292 | BEIGE | 5
605293 | BLACK | 3
605294 | BLACK | 4
 | BRONZE | 4
605295 | BRONZE | 3
 | CREAM | 3
605296 | BLUE | 2
605297 | FUSCHIA | 3
605300 | BEIGE | 3
605302 | RED | 1
 | WHITE | 1
605303 | BLACK | 9
605304 | BLACK | 2
605305 | BLACK | 2
 | BROWN | 2
605306 | BROWN | 3
606019 | BLACK | 0
 | BRONZE | 0
 | SILVER | 0
606020 | BLACK | 0
 | GOLD | 0
607043 | CREAM | 1
608153 | WHITE | 3
619059 | CREAM | 5
619060 | BLACK | 1
 | NUDE | 1
619062 | BLACK | 3
630234 | BLACK | 1
 | WHITE | 1
630238 | BLACK | 7
630241 | BLACK | 4
630242 | SILVER | 2
630243 | BLACK | 2
630246 | MULTI | 1
630248 | BLACK | 5
630250 | BLACK | 9
636091 | NUDE | 2
 | WHITE | 2
636095 | MULTI | 4
636096 | BLACK | 2
636098 | SILVER | 3
636100 | BLACK | 0
 | RED | 0
636101 | RED | 3
636102 | BLACK | 3
636107 | BLACK | 3
638059 | BLACK | 3
639029 | BLACK | 4
706123 | BLACK | 2
 | RED | 2
706126 | GOLD | 1
706127 | CREAM | 0
 | PEWTER | 0
706128 | BLACK | 1
 | GREY | 1
711065 | BLACK | 6
713126 | BLACK | 0
 | SILVER | 0
730032 | CREAM | 2
730033 | BLACK | 1
730036 | BLACK | 5
730037 | GOLD | 2
 | PEWTER | 2
736026 | BLACK | 1
 | WHITE | 1
736027 | MULTI | 4
736028 | NUDE | 4
736029 | BLACK | 0
 | RED | 0
 | TURQUOISE | 0
738069 | BLACK | 1
 | GREY | 1
738079 | MULTI | 1
739018 | BLACK | 0
 | GOLD | 0
803175 | WHITE | 2
803176 | BROWN | 2
803177 | BLACK | 3
803178 | BLACK | 2
 | WHITE | 2
803179 | BLACK | 2
805032 | BLACK | 0
 | PINK | 0
830030 | BROWN | 3
 | PINK | 3
832014 | BLACK | 2
832016 | BLACK | 4
836022 | BROWN | 4
836023 | BLACK | 1
 | WHITE | 1
836028 | BEIGE | 1
 | BLACK | 1
 | CREAM | 1
836029 | BLACK | 1
838030 | BLACK | 5
838031 | BLACK | 1
839028 | MULTI | 2
839031 | CREAM | 4
848050 | BRONZE | 0
 | CREAM | 0
Grand Total |  | 382