Index+Match will produce the same result - however, MATCH returns the number
of the cell in the range (not necessarily the sheets ROW() number).
You can add/subtract 1 from the MATCHs result.
Micky


"boardbug" wrote:

VLookup returns a value in the same row. However, for my purposes I need the
value in a row ahead or a row behind.

So for example if Vlookup formula returns a value in Cell b3, I actually
want to know what it's in the next row i.e. Cell b4 or possibly Cell b2
Does anyone have any thoughts??

Thank you!