Spreadsheet: 41334d1239808471-lookup-from-two-arrays-help
Sheet: Data

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