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

Democat Wrote:
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.


Hi Democat,

I think so...

Can you attach an example cause i cant get it quite clear.


regards,

sam


--
sanskar_d
------------------------------------------------------------------------
sanskar_d's Profile: http://www.excelforum.com/member.php...o&userid=24217
View this thread: http://www.excelforum.com/showthread...hreadid=379602

Hi!

Would not a simple IF function work?
For your data, try
=IF(AND(($A2<C$1+3),($A2C$1-3)),$B2,0) in each cell in columns C thru X,
for all rows having data.

This will work best if you have few lines of data.

Rajni

"Democat" wrote in
message ...

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