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.