+ Reply to Thread
Results 1 to 2 of 2

Index/Match Formula required

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,682

    Index/Match Formula required

    Hi,

    On the attached spreadsheet I have cells where I need to apply an index and match formula but I always struggle how to do this.

    Based on what I think I need, the formula must do the following the following:
    The formula will go in F26, F27 and F28

    I think the index is C6:L9

    Then I need it to match with cells C26,C27,C28 and with J13 (this displays best/expect/worst)

    so for example if a user selects best in cell F26 this should display "86" (the value in cell J7)

    I have attached a spreadsheet example

    Can anyone help?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,682

    Re: Index/Match Formula required

    Not to worry I managed it,

    =INDEX($J$7:$L$9,MATCH(C27,$C$7:$C$9,0),MATCH($J$13,$J$6:$L$6,0))

    Index and match is finally going in my brain

+ 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