Hi

I have an array with a lot of data on Sheet1
Column A list styles
Column B list product
Column C list color code
Column D list color name

on Sheet2, I have dropdown menus
on Col A, you select the style
on Col B, you click on the product
and in Col C, you select the color code

I want to display in Col D the color name

Since I have a lot of color codes for each product
and a lot of products for each style
a VLOOKUP won't work

how can I search for the color names??