Pricing sheet for print shop, estimate based on manual input, selects price to multiply by

So I have a price matrix for screen printing. Basically, you look up both the quantity to print, as well as the colors involved. There are about 7 quantities and 6 colors. I'm looking to make a sheet with those values, and then on a main sheet have a basic form that asks some basic question (how many prints, how many colors, etc), and using the input values, you would get a simple estimate for the order.

I considered nested IF, but that would require about 42 (7 quantities by 6 colors) different IF's (or 41, if the last one is a THEN?). I also tried creating a sheet with a total for every value from 12 to about 500, and then using INDIRECT to look up the value by using the # value input but it doesn't like using a cells value as a variable for the callup.

I considered array, but I have no idea how they work.

Anyone care to help? I'm trying to figure this out for a new position I've taken on, and while it's not absolutely necessary, I feel it would be a big win to be able to get this done.

Thanks!

I'll look at that. Would I be able to use a variable for the input of the test_expression for select case? Also, would I be able to use two values, so that case could cross reference across the quantity and the colors?

I just looked it up, turns out no VBA is available in Excel 2008 for Mac. So back to my original idea: Is there any way to call up a cell on a different sheet using a variable input. So lets say I put 144 into a cell, can I have another cell look up a different sheet, cell A144, where the 144 is gotten from the variable input? If so, then I can just create a super long list of values for each quantity. I'd proably still have to do a nested IF for the colors, but that would actually be less complicated than the crazy web of IF's I'd have to do otherwise.

Actually, if I could use two variables as the lookups for a cell, then I could just create a hidden sheet with literally every cost for every color/quantity combo. It isn't terribly hard, but if I can't use two variable inputs for the lookup, its worthless.