I think there is something wrong with your description of how the points are
attributed to the combination of letters and Roman numerals.

You said AI=20 and BI=19...next higher letter for the same Roman numeral
decreased the value by one

However, you also said AIV=12 and BIV=8... next higher letter for the same
Roman numeral decreased the value by four.

Can you simply list the letter-Roman numeral combinations (there are only 20
of them) with the values you want assigned to them?

Also, are the letters and Roman numerals in separate columns or are they a
text string (like CIII for example)?

--
Rick (MVP - Excel)


"nbach" wrote in message
...
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!