Nested vlookup... or?

[jamesstorx]

I have a sheet (attached) that will have the length specifies and the material. depending on the material that I choose I need to then use Vlookup to find the value associated with that material used for that length. hope that makes sense.

Thanks in advance for any help.

[CRIMEDOG]

Use index - Have an input cell for Material (Ex:A1) and Length (using Data Valedation so it is exact)
Name the Range something like CostTable
Then =Index(CostTable,Match(A1,A2:A25,0),Match(B1,B2:B25,0))
Where A1 is the Material
A2:A25 is the column with the Material Options
B1 is the length
B2:B25 is the row with the length options