I think the @ was a typo, there was no closing quote. I made the same
mistake until I saw the hyperlinking <G

Bob

"Max" wrote in message
...
One way ..

Assuming lookup values in cols A and B, from row1 down

Put in the formula bar for C1,
array-enter (press CTRL+SHIFT+ENTER):

=INDEX({"L";"M";"M";"H"},
MATCH(1,(A1={"L";"L";"L";"M"})*(B1={"L@";"M";"H";" H"}),0))

Copy C1 down
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Kamsa" wrote in message
...
Help, I think I have done this before but cannot remember or how I did
it.

For a risk log, I want a formular that will pick up from 2 cells a
number
of
combinations and give me the result in the third cell

ie. Risk If cell a is "L" and cell b "L@ then cell c should be "L"
however if a is "L" and cell b is "M" then cell c should "M"
and if a is "L and b is "H" then c should be "M"
and if a is "M" and b is "H" then c should "H"