Finding The Right Row To Do A VLOOKUP
Put this in a cell
=Offset($P$41,2-2*row(A1),0)
then drag down the column
the next cell down P39, the row argument would be row(A2) = 2, 2-2*2 = -2
the next cell down P37, the row agument would be row(A3) = 3, 2-2*3 = -4
and so forth.
--
Regards,
Tom Ogilvy
"Minitman" wrote in message
...
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.
|