Help to organise table

[wonderdunder]

I have a table which will be used for Vlookups for cataloguing equipment. The equipment consists of various containers, of various capacities and may be made of differing material.

I currently have a table which is atatched. I have completed the first half dozen or so rows to give an idea of how it will work.

What I want to be able to do is to have a userform that will have three text boxes.

The first will be to select the Measure type (Column B), the second will allow the capacities available for that measure type, and a third will allow the selection of a material.

Also, is there a better way of organising the information? For example, Metal Capacity measures will always be one of three materials, and I don't want to have to have three sets of each one just for different material, but I don't know how to enable a cross reference or whatever. Can anyone help please?

[arthurbr]

Hi, you can find a possible solution at this site

[wonderdunder]

Thanks Arthurbr,

I've given it a go but the number of lists I need is bordering on the ridiculous - I might as well just type out every single combination using that method!

I'm sure I remember from my days using Access that there were linked queries or something similar that would make this a lot easier. Is there an equivalent in excel or any other method?