Thanks both of you!

I tried your solution teylyn and it is sweet Just what I was looking for. I have a Swedish version of Excel so the name of the function was different and the , are instead ;

To any Swedes out there who are looking to do the same thing, here is the Swedish version:

=LETARAD(A2;Blad1!$A$2:$B$3;2;FALSKT)

I am going to try your solution now khamilton.

Again thanks!