I have two variable cells and a definition table. I want to choose a value from the table based on that. View the table below.
Fitch and CCC+ are the two variables in cell 1. I want the number 6 to appear in my output cell, also called Credit quality class. How can I go about doing that?
||Credit quality class|
I tried using INDEX and MATCH functions, but I do not obtain the correct result. It does work if I use IF statement for each column, but that is not what I am looking for.