+ Reply to Thread
Results 1 to 3 of 3

index match issue

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Prefer Excel 2003 but 2007 is great!
    Posts
    1,139

    index match issue

    hello

    i have a summary table in sheet "summary" i would like from my "data" sheet, once i select my district cell C4, it will populate the results into the table on the summary sheet from the data sheet.

    can someone pls help...im not sure how i can approach the index match functionality.

    thx u so much...i have attached a sample.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Prefer Excel 2003 but 2007 is great!
    Posts
    1,139

    Re: index match issue

    hello

    ive managed to make it work...however when i try to drag it across to cell E8 the formula does not work

    i have this formula in cell E8
    {=INDEX(Data!E$9:E$28,MATCH(1,(Summary!$C$4=Data!$B$9:$B$28)*(Summary!$C8=Data!$C$9:$C$28),0),MATCH(Summary!E$7,Data!$D$8:$I$8,0))}
    Last edited by jw01; 04-24-2012 at 11:53 PM.

  3. #3
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,417

    Re: index match issue

    see attached.

    do not use merged cells if you can help it.

    by the way, if you change value in C4, press F9 to recalculate.
    Attached Files Attached Files
    Last edited by icestationzbra; 04-25-2012 at 12:13 AM.

+ 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