Hey everyone,

This is my first post on this site, so I am sorry if I screw up any of the excel lingo.

So here is my problem... I am working in the t-shirt printing business and I am trying to create an instant quote generator on excel, which is linked to an external price list from my wholesaler. Basically what I want to happen, is have the user imput two values into two various cells; the first being the style of a shirt and the second being the color. Once these values are put into their respective cells, I want to have a formula that automatically generates the price of that specific shirt from the wholesalers price list.

Here is a picture of what my worksheet looks like right now...

Capture.JPG

As you can see, the price list that has been given to me by my wholesaler is in a weird format, so I am not sure what formula/function I should use to generate the price given the initial two variables. I would not have a problem rearranging the price list so that it is in an easier format to navigate in excel, but there are thousands of styles, spanning tens of thousands of rows.

Please let me know if you think this is even possible. Any help whatsoever is greatly appreciated.

Mike

Price Generation Sample.xls