Next Row

  • Thread starter Thread starter Jay Easley
  • Start date Start date
J

Jay Easley

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
 
If your vlookup looks like this

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

try this instead

=INDEX(C2:C100,MATCH(A1,B2:B100,0)+1)
 
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




.
Click to expand...
 
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





.
Click to expand...
 
Back
Top