What excel function can I use to return a range of credit ratings given a rating factor?
For example: A1: Credit Ratings B1: Rating Factor A2: Aaa B2: 1 A3: Aa1 B3: 10 A4: Aa2 B4: 20 . . . . . . A23: NR B23: 1,0000 So, if C1 = 15, I want D1 to return “Aa1-Aa2.” If C1=5, I want D1 to return “Aaa-Aa1,” and so on. Thanks.
Public Comments
- The following formula require you to swap the columns to A1: Rating Factor B1: Credit Ratings, others remain as you specified In C1 put your rating factor amount, in D1 you can put this formula =VLOOKUP(C1, A2:B23, 2, TRUE)& "-"&INDIRECT( ADDRESS( MATCH( VLOOKUP( C1,A2:B23, 2,TRUE), B2:B23, 0)+2,2)) Hope this helps.
