Results 1 to 8 of 8

INDEX / Match formulas

Threaded View

  1. #1
    Registered User
    Join Date
    12-14-2010
    Location
    London , England
    MS-Off Ver
    Excel 2007
    Posts
    40

    INDEX / Match formulas

    Hi,

    I have a list of data which I need to index and match into another tab. Unfortunately, I cannot manage the formula as I'm not used to the format of the data list which needs to remain intact.

    In the data list, I have a table for each year (highlighted in red) and in each table, I have 8 clients (column A in blue) and a value attributed (column G yellow).
    In the result tab, I need to match the data list value to the client in column A and year in row 1

    I have tried the below to no avail.

    =INDEX('DATA LIST'!A2:A35,MATCH(RESULT!A2,'DATA LIST'!A2:G36,0),MATCH(B1,'DATA LIST'!G3:G10:'DATA LIST'!G15:G22:'DATA LIST'!G27:G34,0))

    I have attached a spreadsheet as an example. Any help is highly appreciated.
    Attached Files Attached Files
    Last edited by Sophster; 03-11-2011 at 01:17 PM.

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