Lookup first in column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jesper - 28 May 2008 12:29 GMT

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

/

Reply to this Message

Pete_UK - 28 May 2008 12:50 GMT

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

> I have a problem that i can't solve and i hope someone can help me...
>
[quoted text clipped - 17 lines]
>
> /

Reply to this Message

Stefi - 28 May 2008 13:02 GMT

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...
>
[quoted text clipped - 17 lines]
>
> /

Reply to this Message

Jesper - 28 May 2008 13:24 GMT

Works fine, thanks to both of you

/Jesper

> I have a problem that i can't solve and i hope someone can help me...
>
[quoted text clipped - 17 lines]
>
> /

Reply to this Message

Stefi - 29 May 2008 07:21 GMT

You are welcome! Thanks for the feedback!
Stefi

„Jesper” ezt írta:

> Works fine, thanks to both of you
>
[quoted text clipped - 21 lines]
> >
> > /

Reply to this Message