I want to return a single value based on user inputs. The user will put in a
size, material & # of colors. I was using nested hlookups with named ranged
for the tables, but I cant figure out how to use more than one table in the
lookup.

My tables are setup like this:

White
QTY
Size 25 50 100
6 .10 .11 .12
8.5 .13 .12 .11
10 .15 .14 .13

Black
QTY
Size 25 50 100
6 .11 .12 .13
8.5 .14 .13 .12
10 .16 .15 .14

So if the user entered black, size 6 and a quantity of 25, they would get .11

Any suggestions of how to do this?