=match(a1,sheet2!a:a,0)
will give you the row where A1 matches the value in sheet2 column A.

=match(a1,sheet2!a:a,0)+1
will give you the row under the match.

So
=index(sheet2!a:a,match(a1,sheet2!a:a,0)+1)
should return the value under that match.

(as long as there is a match and it's not in the last row!)

Nate wrote:

I'm trying to add a formula that will return the cell directly below the cell
that my VLOOKUP formula pulled from. Any suggestions?

--

Dave Peterson