$40,001 $45,001 $50,001
$45,000 $50,000 $55,000
625 639 A A A
640 679 A A A
680 719 A B B
720 749 B B B
750 779 B C C
780 C C C

Table range is A1:E8

I have this table above which tells me when an account has a total revenues
between $40,001 - $45,000 AND a risk score between 625-639 then it's
classified as an "A" type account.

I have a list of accounts on a separate sheet that gives me the Revenues in
column B and risk score in column C. In column D I want cross reference with
the table above an provide the type of account.

I'm having problems figuring out the ranges lookup in a function.

Thanks for the help