Dave,
I have attemped your formula listed below and continue to get back a #N/A
am I doing something wrong or do I have to try something else?

=INDEX(Sheet2!A1:A6500,MATCH($B17,Sheet2!A1:A6500, 0)+1)

Thanks,

"Dave Peterson" wrote:

Maybe...

=index(sheet2!b:b,match(a1,sheet2!a:a,0)+1)
and
=index(sheet2!b:b,match(a1,sheet2!a:a,0)+23)

or maybe

=index(sheet2!a:a,match(a1,sheet2!a:a,0)+1)
and
=index(sheet2!a:a,match(a1,sheet2!a:a,0)+23)

I'm kind of confused about what should be brought back.

redwing wrote:

using a vlookup I find the info that I am looking for.
I need to send back the contents in the cell that is in the same column but
1 row below the location of the value I found using the vlookup.

I also need to look up the same value again in another instance and return
the info that is 23 rows below the value that i find using the vlookup

--

Dave Peterson