Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookrow
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 |