What I am trying to do, if I can put it into words, is to lookup is the Product Detail, (Col C) as a drop down, by looking up the value in Col B and picking the colour (Colour_1-1...) from product table for the chosen Product Ref i.e. Product_1, Product_2.....).
I hadn't even got to the drop down part yet as I can't seem to find how to lookup the colour based on the column ref. (Column C).
Cant seem to figure aout how to send image or spreeadsheet to view... asking for Http ref????
Not doing very well for my first time