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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookrow
Has the contribution of Gord Dibben MS Excel MVP solved your problem
....yesterday ??? Carim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookrow
weel, yes it works but in this spreadsheet i cannot really use a macro cause
it is for other people who dont want a macro (for some reason) so i did it another way. "Carim" skrev: Has the contribution of Gord Dibben MS Excel MVP solved your problem ....yesterday ??? Carim |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookrow
It is VLOOKUP in English Arne. You are doing an approximate match, to do an
exact match you need another parameter. In English, this would be =VLOOKUP(C3;Blad2!A$4:B$7;2;TRUE) In Swedish =LETARAD(C3;Blad2!A$4:B$7;2;SANT) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Arne Hegefors" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookrow
Bob,
shouldn't this be FALSE for an exact match? Don't know the Swedish for this (!!) but 0 should work instead. Pete Bob Phillips wrote: It is VLOOKUP in English Arne. You are doing an approximate match, to do an exact match you need another parameter. In English, this would be =VLOOKUP(C3;Blad2!A$4:B$7;2;TRUE) In Swedish =LETARAD(C3;Blad2!A$4:B$7;2;SANT) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Arne Hegefors" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookrow
Pete,
Of course, you are correct, I don't know what I was thinking. Good job I gave the English <G Arne, it should be =LETARAD(C3;Blad2!A$4:B$7;2;FALSKT) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Pete_UK" wrote in message ps.com... Bob, shouldn't this be FALSE for an exact match? Don't know the Swedish for this (!!) but 0 should work instead. Pete Bob Phillips wrote: It is VLOOKUP in English Arne. You are doing an approximate match, to do an exact match you need another parameter. In English, this would be =VLOOKUP(C3;Blad2!A$4:B$7;2;TRUE) In Swedish =LETARAD(C3;Blad2!A$4:B$7;2;SANT) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Arne Hegefors" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|