Good Afternoon,

Struggling with the corner way, or anyway for that matter, of implementing the below situation.

On one tab I have invoiced data in a table "SalesData" with a couple columns for customer, sku, date, rev, etc. On a second tab I have information relating to the skus (table "SKU_INFO") with classification information, but the SKU is repeated for each type of classification, ie

SKU Classification Attribute
123 Size large
123 color blue
123 style 454624
125 Size small
125 color yellow
125 style 333424

On the salesdata table I want to add a vlookup/if (?) combo that will lookup the color only for the sold sku, so I would need a vlookup on sku where classification equals "color". Is this possible?

Thanks