After 20 years of manually assigning payment formulas to dates in my
cash forecasting models (it only has to be done once a year), I am
tantalisingly close to doing it by function. In my test case, the 12
monthly paydates are in DC25:DC36 and the amounts are in DD25:DD36.
The days of the year are in DE25:DE389. The array formula
{=IF(DE25=(DC$25:DC$36),DD$25:DD$36,0)} works for any paydate in
January, but not beyond; I just get 0's. =VLOOKUP(DE25,$DC$25:$DD
$36,2,FALSE) works for the whole year, BUT gives me $N/A errors in all
non-paydates which screws up cross-summing. Thanks, Alan Cunningham

Not sure I understand, but try:

=IF(ISNA(VLOOKUP(DE25,$DC$25:$DD$36,2,FALSE)),0,VL OOKUP(DE25,$DC$25:$DD$36,2,FALSE))
__________________________________________________ ____________________


"alancunn" wrote in message
oups.com...
After 20 years of manually assigning payment formulas to dates in my
cash forecasting models (it only has to be done once a year), I am
tantalisingly close to doing it by function. In my test case, the 12
monthly paydates are in DC25:DC36 and the amounts are in DD25:DD36.
The days of the year are in DE25:DE389. The array formula
{=IF(DE25=(DC$25:DC$36),DD$25:DD$36,0)} works for any paydate in
January, but not beyond; I just get 0's. =VLOOKUP(DE25,$DC$25:$DD
$36,2,FALSE) works for the whole year, BUT gives me $N/A errors in all
non-paydates which screws up cross-summing. Thanks, Alan Cunningham