Hi All,

I am looking for a little advice. To give some background I have created a drop down list of products that we manufacture on a tab in excel. I want to use this list so we can create production/manufacturing paperwork that can be used in our factory.

On other tabs I have created the manufacturing specifications which are a list of specifications and cutting sizes that vary depending on the 1st column /size selected. The rest of the data for follows across.

However for the three products the manufacturing specifications are different so what I want to know is can I create a formula that says if I select product A then look at product A's specification tab, if I select product B select product B's specification tab or if I choose product C then look at product C's specification tab?

I can create a vlookup formula that works for one product and drops the necessary information into a sheet I have designed but I don't know to get it to distinguish the correct cutting info depending on the product type selected.

Any help and advice would be much appreciated.