If your VLOOKUP formula was something like this:

=VLOOKPU(A1,A2:B100,2,0)

Then try something like this:

=INDEX(B2:B100,MATCH(A1,A2:A100,0)+1)

--
Biff
Microsoft Excel MVP


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