Next Row

I am using a vlookup to find a value in a list and then
directly below that I would like to find the value beneath
the value found in the list. For example:

1
2
3

I am given a 1.2, the volookkup returns 1 and then I would
like to return a 2 below that.

thanks for any and all help,
Jay Easley

Hi Jay,
With the number to be looked up (1.2 in your example) in A1, use
=INDEX(myList,MATCH(A1,myList,1)+1)
where myList is the array {1,2,3} in your example.

Match finds what row it is in and Index returns a value from a given row. SO
adding one does the trick.
Bernard

"Jay Easley" wrote in message
...
I am using a vlookup to find a value in a list and then
directly below that I would like to find the value beneath
the value found in the list. For example:

1
2
3

I am given a 1.2, the volookkup returns 1 and then I would
like to return a 2 below that.

thanks for any and all help,
Jay Easley

If your vlookup looks like this

=VLOOKUP(A1,B2:C100,2,FALSE)

try this instead

=INDEX(C2:C100,MATCH(A1,B2:B100,0)+1)

--

Regards,

Peo Sjoblom


"Jay Easley" wrote in message
...
I am using a vlookup to find a value in a list and then
directly below that I would like to find the value beneath
the value found in the list. For example:

1
2
3

I am given a 1.2, the volookkup returns 1 and then I would
like to return a 2 below that.

thanks for any and all help,
Jay Easley

Thanks for the help!!
-----Original Message-----
Hi Jay,
With the number to be looked up (1.2 in your example) in
A1, use
=INDEX(myList,MATCH(A1,myList,1)+1)
where myList is the array {1,2,3} in your example.

Match finds what row it is in and Index returns a value
from a given row. SO
adding one does the trick.
Bernard

"Jay Easley" wrote in message
...
I am using a vlookup to find a value in a list and then
directly below that I would like to find the value
beneath
the value found in the list. For example:

1
2
3

I am given a 1.2, the volookkup returns 1 and then I
would
like to return a 2 below that.

thanks for any and all help,
Jay Easley


.

Thanks for your help!
-----Original Message-----
If your vlookup looks like this

=VLOOKUP(A1,B2:C100,2,FALSE)

try this instead

=INDEX(C2:C100,MATCH(A1,B2:B100,0)+1)

--

Regards,

Peo Sjoblom


"Jay Easley" wrote in message
...
I am using a vlookup to find a value in a list and then
directly below that I would like to find the value
beneath
the value found in the list. For example:

1
2
3

I am given a 1.2, the volookkup returns 1 and then I
would
like to return a 2 below that.

thanks for any and all help,
Jay Easley


.