+ Reply to Thread
Results 1 to 4 of 4

Index & Match help required

  1. #1
    Registered User
    Join Date
    02-24-2015
    Location
    Guernsey
    MS-Off Ver
    2010
    Posts
    8

    Index & Match help required

    I have a Workbook which I have copied part of (attached) which manipulates English Premiership football results. I currently input the results manually each week, but download results from a soccer site (PremResults), and wish to add them automatically. I know it can be done with INDEX & MATCH but have tried numerous variations but am getting more confused with each failure. Help please experts.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-16-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: Index & Match help required

    I looked at your file but I know nothing about football!
    I am sending you a link for a video that I created for index/match
    https://www.youtube.com/watch?v=mdhOWtgn-IE

    http://www.easyexcelanswers.com

  3. #3
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Rocester, New York, USA
    MS-Off Ver
    Excel 2007:10
    Posts
    2,019

    Re: Index & Match help required

    My advice is don't bother with a table built from Index/Match because setting it up is harder than the alternative:

    Throwing the data into a Pivot Table. (See Attached).

    You can run the PT off an external data connection too, so updating the table becomes automatic.
    Attached Files Attached Files
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    21,308

    Re: Index & Match help required

    INDEX/MATCH ...

    =IFERROR(INDEX(PremResults!$E$3:$E$142,MATCH(1,($C5=PremResults!$C$3:$C$142)*(G$4=PremResults!$D$3:$D$142),0)),"") home tean

    =IFERROR(INDEX(PremResults!$F$3:$F$142,MATCH(1,($C5=PremResults!$C$3:$C$142)*(G$4=PremResults!$D$3:$D$142),0)),"") away team

    See attached (I have done first row & column)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 10-16-2016, 02:33 AM
  2. [SOLVED] Help required with match and index functions
    By frosty_1977 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-11-2015, 06:01 PM
  3. [SOLVED] Formula required (Index, Match)
    By nagesh.tvsr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-18-2014, 01:30 AM
  4. Index/Match Excel Formula assistance required
    By coyy in forum Excel General
    Replies: 3
    Last Post: 12-10-2012, 09:21 AM
  5. Index/Match Formula required
    By pauldaddyadams in forum Excel General
    Replies: 1
    Last Post: 01-27-2012, 06:45 AM
  6. Index Match only 4 results required
    By pepe.r.taylor in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-31-2011, 11:28 PM
  7. Excel 2007 : INDEX/MATCH help required
    By 5foot9 in forum Excel General
    Replies: 1
    Last Post: 07-22-2011, 02:02 PM

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