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.