Results 1 to 4 of 4

Thread: Index Match
Thanks Thanks: 0 Likes Likes: 0

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

    Default Index Match

    Hello
    if I can find the ROWS and COLUMNS using MATCH how do I find out what is in the range


    =MATCH($O$38,Holidays!$A$4:$A$92,0) returns the row number. result=19
    =MATCH($Q$37,Holidays!$A$3:$OE$3,0) returns the Column number result=184

    How do I find out what is in column 184 and row 19, which will be GB22. and my result is H

    can someone help me write a formula that puts it all together

    many thanks Jason

  2. #2
    MrExcel MVP Eric W's Avatar
    Join Date
    Aug 2015
    Location
    Bountiful, UT
    Posts
    8,628
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Index Match

    Try:

    =INDEX(Holidays!$A$4:$OE$92,MATCH($O$38,Holidays!$A$4:$A$92,0),MATCH($Q$37,Holidays!$A$3:$OE$3,0))
    Last edited by Eric W; Jul 15th, 2019 at 04:45 PM.
    Cheers,
    Eric

    When you eliminate the impossible, whatever remains, however improbable, must be the truth.

    -Posting guidelines, forum rules, terms of use, FAQs, BB codes, See how to search the forum
    -Post a screen shot with the HTML Maker

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

    Default Re: Index Match

    BISH BASH BOSH
    thank you
    you are a star

  4. #4
    MrExcel MVP Eric W's Avatar
    Join Date
    Aug 2015
    Location
    Bountiful, UT
    Posts
    8,628
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Index Match

    Glad to help!

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
  •