I am using Excel 2003.

I need help auto populating cells depending on what previous cells are showing.

In Column A, I have a drop down list with a series of products.

In Column B, I have a drop down list with two options, relating to those products in Column A.

Column C is my Quantity column, and that value would be inputted manually.

Column D is my Price Per column, and I would like that to auto populate, based on what is showing in Column A and Column B. So for example, if Column A is showing Product ABC and Column B is showing Option 1, it would be a different price than if Product ABC was paired with Option 2 in Column B.

Column E would be total amt, just a simple price per x qty.

I have absolutely no idea how to set up the relationship between Columns A and B, and Column D.

Any help would be much appreciated!

-Cyndi