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.

What excel function can I use to return a range of credit ratings given a rating factor?
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)%26amp; "-"%26amp;INDIRECT( ADDRESS( MATCH( VLOOKUP( C1,A2:B23, 2,TRUE), B2:B23, 0)+2,2))


Hope this helps.