Hi Guys,
I've spent 2 days trying to figure out how to do this!
Basically I have created 3 Drop Down menu's in my excel sheet. From here I need to have specific information placed in different cells depending on what combination of words are chosen in have in my drop down menu. Is this possible?
I have tried to use IF's but have failed, #VALUE! everytime! I've got no idea what else to try.
I have attached my workings so far. As you will see I have the 3 Drop Down menu's, (GARMENT, RANGE, DESIGN) In another worksheet I have our range with all the relevant information on our garments. Price, Printing Options, Embroidery, Colour Range etc. This is where I need to pull the information from top place into the relevant cells, and add prices to the correct boxes.
So for example: I have chosen "HOODIE" from my GARMENT drop down menu, "FRESHMAN" from my RANGE drop down menu and "DESIGN 2" from my DESIGN menu. Which all refer back to a specific garment in my "range worksheet" That would mean under GARMENT DECORATION "P1 COLOURS" and P2 COLOURS (Meaning PRINT POSITION 1/2 amount of colours), I need it to say from the "range worksheet" 2 in both of those boxes. From there I will insert the quantity and specific sizes and it then needs to come up with a price per garment which is also in the "range worksheet".
More complex is that I need to be able to input the correct sizes and it will calculate the amount of material needed for each size, so that will in the end change the final cost price. But I might tackle this bit once I get the 1st problem sorted.
Thanks in advance!
Cheers
BoardGirl
Bookmarks