+ Reply to Thread
Results 1 to 6 of 6

Index, Match, Offset? Not sure which to use

  1. #1
    KL
    Guest

    Re: Index, Match, Offset? Not sure which to use

    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.
    >




  2. #2
    KL
    Guest

    Re: Index, Match, Offset? Not sure which to use

    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.
    >




  3. #3
    KL
    Guest

    Re: Index, Match, Offset? Not sure which to use

    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.
    >




  4. #4
    KL
    Guest

    Re: Index, Match, Offset? Not sure which to use

    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.
    >




  5. #5
    Ms. P.
    Guest

    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.


  6. #6
    KL
    Guest

    Re: Index, Match, Offset? Not sure which to use

    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.
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1