Lookup first in column
 

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

/

Lookup first in column
 

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

On May 28, 12:29*pm, Jesper wrote:
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

/

Lookup first in column
 

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


€žJesper€� ezt Ã*rta:

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

/

Lookup first in column
 

Works fine, thanks to both of you

/Jesper

"Jesper" wrote:

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

/

Lookup first in column
 

You are welcome! Thanks for the feedback!
Stefi

€žJesper€� ezt Ã*rta:

Works fine, thanks to both of you

/Jesper

"Jesper" wrote:

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

/