Norm, first - I think I provided a fix to the problem in the other discussion
on VLOOKUP(). Check it out.

Now, for this problem. If Row 16 on Sheet2 is the one where you have
Apr11-17 shown in your example, that's probably not a real date and while you
could use VLOOKUP() to return those values just as before, another way to get
the values from a column on Sheet2 associated with dates would be like this.

Assumptions:
Sheet2 has dates in column A
In sheet 1 you have the start date in C4 and the end of period date in D4
(could be any other cell, but D4 for this example). Then
=SUMPRODUCT(--(Sheet2!$A:$A=$C$4),--(Sheet2!$A:$A<=$D$4),--(Sheet2!B:B))
would give you the total of values in column B as a result. The way I've
set up the formula, you can then drag it to the right on your sheet and the
final column will change from B, to C, to D, to E, etc depending on how far
across the sheet you drag or fill it.
If you put 11-Apr in C4 and 17-Apr in D4, then it would give you the totals
for that period.


"Norm" wrote:

I need to get the information from sheet 2 row 16 using the date in sheet 1
C4 and the same date in sheet 2 A16
sheet 1

REPORT DATE 4/12/2010
APR 11 - 18
KPI No Genesis KPI's UOM

sheet2

15-Apr
16-Apr
17-Apr
Apr11-17 11 19 10
18-Apr
19-Apr

or can I lookup a sum of cells using a range of dates?
Thanks