=IF(AND(A2="jumper",B2="wool"),3, AND(A2="shirt","B2="silk"),5,""))

in C2

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"cerobeth" wrote in message
...
I am trying to create an order form where column A has a drop down box to
choose an item and column B has a drop down box to choose a category.
Depending on the choices selected I need to create variable prices.

ie if A = jumper, B = wool then C = £3, but if A = shirt, B = silk then C
= £5

Can anyone help me please