Thank you for your response, I really appreciate it. However, I tried the
formula suggested and I get an #N/A. Should I enter this formula as an array?
Even so, I still get the #N/A error. Regarding your comment on putting the
data in one cell, I don't want it in one cell. I want it to be the same
number of columns ands rows as what it's retrieving. Any other idea?
thanks again.

"KL" wrote:

Hi,

The following the array you describe, but obviously it can't be viewed as a
result in one cell - you can however manipulate it in some further
operations no problem:

=OFFSET(INDEX(Sheet2!A:A,MATCH(D1,Sheet2!A:A,0)),-6,2,7,10)

Regards,
KL


"Ms. P." wrote in message
...
Here's what I have. I would like to enter a date in one worksheet and
based
on that date, find the date in the second worksheet and place a range of
data
it into the first. For example:
On worksheet 1 I want to enter a date into cell d1, then I need it to look
for the date in column A on worksheet 2 and when it finds it return a
range
of data thats 6 cells up and 2 to the right, 7 high and 10 wide. I'm not
having any luck. I appreaciate any help you can provide.