=OFFSET(E1,MATCH(A1,E1:E200,0),0)

Your use of VLOOKUP() returns the value and not the position.
--
Gary''s Student - gsnu200854


"Accesshelp" wrote:

Hello all,

I need help with a formula.

I have values in cells A1 and E1:E200. In cell G1, I want to write a
formula with this logic:

Look at the value in A1, and if the A1 value matches with one of the values
in E1:E200, pick the next value in E1:E200. For example, if A1 values
matches with E100 value, pick E101 value. All those values are date values
in this format 5/22/2009.

I tried to use this formula in G1, and it didn't work.

=offset(vlookup(A1,$E$1:$E$200,1,false),1,0)

Please help. Thanks.