I have [column-a] dates and [column-b] corresponding amounts. Column-c
thru -x are weekly periods represented by the Wednesday date of each
week in [row1].
Can I use the LOOKUP function to find the week [date +- 3days] and
place the amount in the proper column? Will an alternative function
work better.
Please help. I imagine scheduling amounts by period is a common
useage.
--
Democat
------------------------------------------------------------------------
Democat's Profile:
http://www.excelforum.com/member.php...o&userid=24362
View this thread:
http://www.excelforum.com/showthread...hreadid=379602