Looking up new bar codes and matching to product.

Thanks....didn't work, but seems to be on correct concept. Problem is probably my fault for inadequate explanation.
I've attached a slightly longer "products" sheet and highlighted the variable columns that might be used.
For each color there are new barcodes that fit for each size of XS, SM, MD, and LG (and there is no new bar code for XL). These are on the sheet for EACH color...I include three colors vertically in column D: "Adopted", "Aloha Breeze" and "American Flags"...each with the sizes to match the colors on the "barcodes" sheet.
You can see what I'm trying to do....make a formula that can be copied down the "New barcodes" column K on the "Products" sheet which has vertical orientation from the "barcodes" sheet which has horizontal orientation.
A tough one!!
thanks,

rsuits

code matching to products (2).xlsx