Please help with a formula
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.
|