J
JeffK
$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
$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