look.row

[nada]

Hi! I use swedish xl but i think the function i am using is called Lookrow.
Anyway I use that function (you will figure it out). I have a list in column
C that contains the rating for banks. In another worksheet I have a list of
all possible ratings in column A and a list of percentages in column B. Eg:
AAA 5%
AA 12%
A 3%
etc
In column F I use the lookrow function to match the rating for a firm with a
percentage. eg if the firm has rating AA I want to show 12% in column F. This
works fine except for the ones with rating A, then my function says that no
values can be found.

in swedish my formula looks like:
=LETARAD(C3;Blad2!A$4:B$7;2)

Please help me with this problem! Ps I know that you can that function to
look for approx values but I would like to use the exact one in order to make
no mistake ds

 

[fabriciofcmiranda]

Hi, Nada. Try adding a "0" at the end of your expression. e.g.: =LETARAD(C3;Blad2!A$4:B$7;2;0). Check if it works.

 

[nada]

hi. solved it. i had to change the order of the table so that it was like: BBB, A, AA, AAA. then it works!