Getting results from multiple Lists

[torque_nut]

I want to be able to use list as filters that will show me results for prices I need. I have no idea how to figure this out. Any help is welcomed. I attached a sample file so you can see what I'm trying to do.

[NBVC]

Try this formula:

=INDEX($B$3:$H$14,MATCH(G16,$A$3:$A$14,0),MATCH(B16,$B$2:$H$2,0))

[torque_nut]

That worked awesome, Thank You. If I want to add more lists do I just keep adding matches to meet my criteria? And is there a way to filter my lists based on the list before? For example, say "A glass only has two types of glass but "B Glass" has eight types. Can My first list filter out what the second list will show? And thanks much for the quick response!!!

[NBVC]

That worked awesome, Thank You. If I want to add more lists do I just keep adding matches to meet my criteria?

Not sure exactly what you mean, but I think the answer is not really...that is not how it works, the first Match is for the Row and the Second is for the Column... so you have to have a table like you presented where the price is at intersect of row/column...

You can, however, have a separate table, and then create a nested formula that first looks in one table, then in the other...

And is there a way to filter my lists based on the list before? For example, say "A glass only has two types of glass but "B Glass" has eight types. Can My first list filter out what the second list will show? And thanks much for the quick response!!!

See here for instruction:

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

[torque_nut]

I got all the info I need to help get this going. Thank you very much!!