Lookup first in column

J

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

/
 
P

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
 
S

Stefi

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


„Jesper†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top