Need Help Getting Price to Autofill For a products with three price options

I am working on an order form. I have 20+ products that have three different prices based on the three different treatments each product can treated with. The base prices are different for every individual product, and therfore treatment level.

So in Column A I have the dropdown of products.

Column B, the dropdown of the three treatment products that can be done to each product in column A.

Need to autofill column C, the price.

On another worksheet I have a table with products in column A, treatment 1 price in Column B, treatment 2 price in column C, and treatment 3 price in column D.

I have no idea on what formula to use to make this work.

Please help!!

Fort Morgan Seed Order Form.xlsm

sheet two, rows 3-25, and a seperate formula for rows 32-43

Thanks!

Ok so I deal with two seed companies. On sheet one, i have a Channel side and a Dekalb side, the two seed companies. So for the Dekalb side, I need the hybrid/variety column(product) to correlate with the seed treat column (250, 500, or 1250) which is one column over from the hybrids. That will determine the price for the cost per unit column.

I need the exact same for the channel side.

Dekalb hybrids are the top set on sheet two, and channel hybrids are the bottom set of hybrids.

I didnt get that formula you gave to work.

Actually, i did get it to work!! now can we add a fuction that if blank, leave zero instead of #N/A??

See the workbook I posted!

Also put in G18

Formula:

Please Login or Register  to view this content.

And in O18

Formula:

Please Login or Register  to view this content.

And drag down that will clean the sheet up in the 2 columns.

That Worked!! Thanks!!

Can you do the same thing for this file for me?? This has two treats(treated, Untreated) But again, one for channel and one for dekalb

Soybean Seed Order Form.xlsm
Sorry, heres the workbook

Here I have just noticed that in your profile you have 2003. Rightly or wrongly, I thought .xlsm files were for 2007 & up.

Here's your file with formulas in F18 & N18.I see you only have one price list ASGROW!

Excel 2007 & 2010

In F18

Formula:

Please Login or Register  to view this content.

In N18

Formula:

Please Login or Register  to view this content.