Lookrow

[Arne Hegefors]

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

 

[Carim]

Has the contribution of Gord Dibben MS Excel MVP solved your problem
....yesterday ???

Carim

 

[Arne Hegefors]

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:

 

[Bob Phillips]

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)

 

[Pete_UK]

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]

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)