Hi Leslie

If you are going to have 20 rates, then you will be better off with a
Table. The table can exist on another sheet if required.
Starting with a new sheet, enter in
A2 Dust
A3 Grit
A4 Something else

In
B1 5
C1 7
D1 9
In
B2 $5.00
C2 $7.50
D3 $9.50

Complete the matrix with whatever are the appropriate numbers for the
different cases that you have.
In cell F32 of your Sheet1 enter
=INDEX(Sheet2!$A$1:$D4,MATCH(C6,Sheet2!$A$1:$A$4,0 ),
MATCH(D5,Sheet2!$A$1:$D$1,0))

Amend the ranges to suit the size of the Table you create
--
Regards

Roger Govier


"Leslie" wrote in message
...
I need a way to make formulas dependent on two conditions.

example:. C6 is the word Dust
D5 is the number 9
this would make F32 $9.50

I want to put rates in to come up when the word and number equal a
rate. I
have around 20 different ones.