Results 1 to 3 of 3

Index, Match in table

Threaded View

  1. #1
    Registered User
    Join Date
    12-03-2008
    Location
    The Swamp
    MS-Off Ver
    2000 Pro
    Posts
    75

    Index, Match in table

    I have a table with the months from B1:M1 & Customers from A3:A35. B3:B35 are transaction numbers.

    On another sheet, I have a cell, C2 with the name of the month that I type in, I've named it MONTH. I also have a seperate section for each customer that NBVC has helped me populate from another sheet based on MONTH and their actual transactions.

    At the bottom of the section, I want it to populate from this other table based on the month in the MONTH cell.

    I've created this formula, but it's not giving me the right information.

    =INDEX('CTR''S 2008'!B3:M35,MATCH(MONTH,'CTR''S 2008'!B1:M1,0),MATCH($B$4,'CTR''S 2008'!A3:A35,0))
    Last edited by Georgia Golfer; 01-12-2009 at 04:49 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