Index match
Results 1 to 6 of 6

Thread: Index match
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2003
    Location
    UK
    Posts
    510
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Index match

    Good morning
    could someone please help me out with an INDEX MATCH
    I'm trying to find dates when people are on holiday.
    my index are DATES on K27:N27. THE NANE J28:J33. THE HOLIDAYS H29:K28
    H28 is the name
    H29 is the letter H

    so I'm trying to find the name and then the H and return the date that the person has booked off on holiday but currently it returning a N/A error.

    and then once that one works I would like to be able to find the next day they have booked off, how do you find the second date, third date?

    thanks you



    =INDEX(K27:N27+MATCH(H28,J28:J33,0),MATCH(H29,K28:N33))

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,042
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Index match

    Is this a typo ???

    =INDEX(K27:N27+MATCH(H28,J28:J33,0),MATCH(H29,K28:N33))

    It should be

    =INDEX(K27:N27,MATCH(H28,J28:J33,0),MATCH(H29,K28:N33))

    For subsequent dates you'd be better off posting some example data

  3. #3
    Board Regular
    Join Date
    Apr 2003
    Location
    UK
    Posts
    510
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Index match

    hello

    some post i've read i've seen a + either way i'm still getting the error code
    thank you

  4. #4
    Board Regular Aryatect's Avatar
    Join Date
    Jun 2019
    Location
    Chicago, USA
    Posts
    300
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Index match

    Hi,

    Can you post some dummy data, some of your ranges are intersecting.
    Thanks!

    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

  5. #5
    Board Regular
    Join Date
    Apr 2003
    Location
    UK
    Posts
    510
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Index match

    Hi Aryatect
    How do I do that

  6. #6
    Board Regular Aryatect's Avatar
    Join Date
    Jun 2019
    Location
    Chicago, USA
    Posts
    300
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Index match

    Hi,

    Use any of the tools in the below link to use an addin to paste the data:

    https://www.mrexcel.com/forum/board-...forum-use.html
    Thanks!

    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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