View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AccessHelp AccessHelp is offline
external usenet poster
 
Posts: 213
Default 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.