Indexing matching and dropdown boxes

[BKapadia]

Hi, im trying to create a excel that uses the previous cells dropdown box option as a reference. Then takes that data and searches another sheet for options listed below it and repeates several times referncing the cell before. Not sure if ive explained it well. Ive provided a doc. Sheet 1 is like an entry area where people enter data based on dropdown boxes that use data from sheet 2.

I want it to search specified rows from sheet 2 (sometimes several rows, ex. search Row 12 and Row 17 from sheet two for the key term chosen from the sheet 1s selection, then list the options below it from sheet 2 in a dropdown in sheet one

[Ace_XL]

This might help..

http://www.contextures.com/xlDataVal02.html

[BKapadia]

That definatly helps me understand the concept, but I need something a bit more Scalable. So that if i need to add something to it late on, for an earlier selection, I dont have to adjust Range of each Named table, as this would be a rather larger scale document.

[Tinbendr]

This creates all the named ranges required of the contextures concept page.

There is a problem with the Sub types, but I ran out of time. I'll try again later.

[BKapadia]

Thanks Tinbendr, seeing it in that structure really helped, thanks ! Going to test it with tables now but looks good! U dont need to revise it or anything.