Lookup first in column

[Jesper]

I have a problem that i can't solve and i hope someone can help me...

I have this matrix

A B
1 JJ 45
2 FN 35
3 FN 22
4 JJ 99
5 FN 30

And want to X and Y to be 45 and 35. I.e. that the first value in the column
is but in column B in matrix below

A B
1 FN Y
2 JJ X

Thanks in advance

/

 

[Pete_UK]

I presume these are on two sheets, as you have used the same columns.
Assume your longer list is on Sheet1, then in B1 of Sheet2 you can
enter (for Y):

=VLOOKUP(A1,Sheet1!A:B,2,0)

Then just copy this formula into B2 of sheet2.

Hope this helps.

Pete

 

[Stefi]

Try this in sheet2 A1 and fill down:
=INDEX(Sheet1!A:A,MATCH(B1,Sheet1!B:B,0))
Regards,
Stefi


„Jesper†ezt írta:

 

[Jesper]

Works fine, thanks to both of you

/Jesper

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„Jesper†ezt írta: