View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default Finding The Right Row To Do A VLOOKUP

I think I understand. One question, with OFFSET how do you get it to
move up? Lets say my first location is in P41 and the next location
is in P39 and the next is in P37 and so on. How would that be
written?

-Minitman



On Sun, 30 Oct 2005 21:58:45 -0500, "Tom Ogilvy"
wrote:

If you don't know the date for the first location in Weekly (B2), then I
don't know what to tell you. If you do, then I gave you the fromula to find
the day in daily.