You need to create a clearer description of your problem in order to get the
solution you are looking for. Try to simplify your problem, preferably focusing
on one row. Normally when you get the solution for one row, you can copy down
for the rest.

Another useful technique is to ask for one solution at a time. For example,
create another post solely for your date lookup problem. This will help you
specify the problem more clearly. For example, if "A & C may not always match
the dates in the lookup ranges", then tell us what the rules are so they will
always match.

It looks to me like you are trying to calculate the shares resulting from a
dividend reinvestment program. Is this correct? If so, why does F3 (presumably
for a dividend declared between 2/6/99 {is 2/16/99 a typo?} and 2/12/99) extract
a price of 15.94 when that occurred on 3/12/99? Is 3/12/99 the dividend
reinvestment date? If so, then I think you will need to add this date to your
row. This will then allow you to look it up.

Hope this helps.

--
Regards,
Fred


"AG" wrote in message
...
I need formulas to calculate a dividend when it occurs between 2 dates.
I've tried a few options & looked through the group but I don't have the
skill to put the info I found to use.
Thanks for any help.

I have a sheet named "Value" as setup below.
I have ranges for dividend rates and daily prices as below.
What I need are the formulas to extract the Div Rate for column E and the
Div Price for column F.
So that I extract .25 for cell F3 and 15.94 for cell G3 and 0.484 for cell
F8 and G8 when they occur.
The lookup values in columns A & C may not always match the dates in the
lookup ranges and finding the closest match that results using a standard
lookup function won't always be correct.


Value Sheet
Monday Friday Current Div
Added Total
Date Price Date Price Shares Rate Price Shares
Shares
2/8/99 16.3 2/5/99 16.28 1000 1000
2/16/99 15.94 2/12/99 15.86 =I2 .25 15.94 15.684
1015.684
2/22/99 16.07 2/19/99 15.8 =I3
3/1/99 15.82 2/26/99 15.85 =I4
3/8/99 16.23 3/5/99 16.24 =I5
3/15/99 16.4 3/12/99 16.43 =I6
3/22/99 15.96 3/19/99 16.45 =I7 0.484 16.44 29.957
1045.641
3/29/99 15.86 3/26/99 15.69 =I8

DivTable set as a named range
Date Rate
3/4/99 2.038
3/12/99 0.25
3/17/99 0.484
3/30/99 0.063

PriceTable set as a named range
Date Price
3/3/99 15.84
3/4/99 16.02
3/5/99 16.24
3/8/99 16.23
3/9/99 16.16
3/10/99 16.34
3/11/99 16.36
3/12/99 15.94
3/15/99 16.4
3/16/99 16.41
3/17/99 16.44
3/18/99 16.58
3/19/99 16.45
3/22/99 15.96
3/23/99 15.63
3/24/99 15.75
3/25/99 15.82
3/26/99 15.69
3/29/99 15.86
3/30/99 15.63