I need to figure out a formula (or a set of formulas) to get a number off of
a combination of two different drop down lists.

My two lists are like this:
A - Frequent
B - Probable
C - Occasional
D - Remote
E - Improbable

and:
I - Catastrophic
II - Critical
III - Marginal
IV - Negligible

I need to combine it so that each different combination gives you a
different risk number. Like A and I gives you 20, B and I = 19, A and IV =
12, B and IV = 8 and so on.

I know how to do the formula when it is two static cells
=IF(AND(B4="A - Frequent", C4="I - Catastrophic"), 20, 0)

And I have seen examples of how two use a VLOOKUP with a list, which seems
like what I need to use, but I don't know how to get it to work when you need
to combine two different lists to get one result.


Can anyone help me with this? I've seen all the different formulas that
seem to be what I need, but I'm at a loss to figure out how to put them
together.

Thanks!