+ Reply to Thread
Results 1 to 7 of 7

Using Match, Index and concatate to populate a fixture table.

  1. #1
    Registered User
    Join Date
    02-14-2013
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    17

    Using Match, Index and concatate to populate a fixture table.

    Hi Smart people,

    I will admit, this one is a little confusing for me and I need some assistance.

    Comp List.JPG

    I am trying to create a fixture table like in the image, but using the results as formatted below it.

    I have completed everything else but would like to add this bit to my over all data entry.

    I have tried various combinations on Match, Index mixed with Concatate... but I seem to get odd results.

    Can anyone help me with an explanation on how I should be ordering these things..

    basically, I am trying to have excell find:

    the row labeled team A and then the column labeled Team B.
    Search the results that I type in as below the table.
    And then concatate them into the fixture table.

    Am I trying something crazy or can it be done?

    Thank you all in advance for any assistance.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2211
    Posts
    36,794

    Re: Using Match, Index and concatate to populate a fixture table.

    Hi there... and welcome to the Excel Forum. I can only see the score for ONE side for each match.... You have attached an image. That's not very easy to work with. We have to re-type your information before we can begin to address your problem. That will put a lot of people off completely. Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Glenn



  3. #3
    Registered User
    Join Date
    02-14-2013
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Using Match, Index and concatate to populate a fixture table.

    thanks Glenn,

    It was just a number and didnt notice it missing..

    Here is an updated image

    Comp List.JPG

    From What I understand, I am probably going backwards with the index and match functions..

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2211
    Posts
    36,794

    Re: Using Match, Index and concatate to populate a fixture table.

    Can you post an excel sheet, as previously requested?

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2211
    Posts
    36,794

    Re: Using Match, Index and concatate to populate a fixture table.

    Forget it. It only took a couple of moments. Try this...
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-14-2013
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Using Match, Index and concatate to populate a fixture table.

    Thanks Glenn,

    I knew I was confusing myself, I really appreciate the assist. I can stop pulling my hair out now.

    Fooz

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2211
    Posts
    36,794

    Re: Using Match, Index and concatate to populate a fixture table.

    Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

+ 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. Vlookup or Index Match to populate multiple values
    By HB07 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-30-2015, 05:18 AM
  2. [SOLVED] Index Match/Populate data based on key value
    By mzafar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-03-2013, 01:49 PM
  3. Index, Match and populate data
    By danmar7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2010, 03:19 PM
  4. Populate listbox using vlookup or index,match?
    By sarahng86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2007, 08:42 AM
  5. INDEX/MATCH formula in VBA to populate text boxes
    By Amber_D_Laws in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-17-2006, 12:19 PM

Tags for this Thread

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