Index, Match, Offset? Not sure which to use

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.

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." <MsP@discussions.microsoft.com> wrote in message
news:79D85697-91E8-45DD-811E-5E6D5C702B13@microsoft.com...
> 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.
>

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." <MsP@discussions.microsoft.com> wrote in message
news:79D85697-91E8-45DD-811E-5E6D5C702B13@microsoft.com...
> 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.
>

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." <MsP@discussions.microsoft.com> wrote in message
news:79D85697-91E8-45DD-811E-5E6D5C702B13@microsoft.com...
> 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.
>

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." <MsP@discussions.microsoft.com> wrote in message
news:79D85697-91E8-45DD-811E-5E6D5C702B13@microsoft.com...
> 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.
>

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." <MsP@discussions.microsoft.com> wrote in message
news:79D85697-91E8-45DD-811E-5E6D5C702B13@microsoft.com...
> 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.
>