=IF(AND(A1="red",A2="blue"),10,IF(AND(A1="green",A 2="orange"),20,IF(AND(A1="purple",A2="yellow"),30, 0)))

You said you need to replicate this down column of 5 rows? That makes me
think that maybe your A1 and A2 references might really be A1 and B1?? But
in any case, the formula above should get you going. That last zero in the
formula could even be changed to a phrase like ,"Not a correct pairing")))


"Shelly" wrote:

Hello - I've searched, but cannot find what I'm looking for... I need to do
this:

In the cell A3 the formula should say

If A1 = "red" and if A2 = "blue" enter 10 in A3, or
If A1 = "green" and if A2 = "orange" enter 20 in A3, or
If A1 = "purple" and if A2 = "yellow" enter 30 in A3.

And, I will need to replicate this down a column of 5 rows.

THANKS!!