+ Reply to Thread
Results 1 to 4 of 4

Index,match function trouble with formula

  1. #1
    Registered User
    Join Date
    01-18-2013
    Location
    Saint Louis, Missouri
    MS-Off Ver
    Excel 2007
    Posts
    9

    Index,match function trouble with formula

    I am trying to write a function with INDEX,MATCH. I have attached a sample worksheet for an example. My first worksheet "employee stats" lists all employees and their number of clients. The adjacent worksheets list the employees separate with a detailed listing of their client load. What I am trying to do is take the total # of clients in sheet 2 (employee 1) which would be cell B22 and have it automatically populate on sheet 1 (employee stats) into the appropriate cell, which in this case for employee 1 would be C4 for current month for employee 1. I hope this makes sense as I have been beating my head against the wall! Thanks in advance for any help you can offer! Thanks so much!!
    Attached Files Attached Files

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Index,match function trouble with formula

    tuckerbunch,

    Using your provided example file, in sheet 'Employee Stats' cell H1 put in this formula:
    Please Login or Register  to view this content.
    Next in sheet 'Employee Stats' cell C3 and copied down:
    Please Login or Register  to view this content.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    01-18-2013
    Location
    Saint Louis, Missouri
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Index,match function trouble with formula

    I am sorry. I am so confused. I am obviously very new to this and am self teaching so please be kind I don't know if I don't understand your reply or if I didn't explain what I was trying to do correctly. Sheet 1 "employee stats" is simply a quick glance sheet to get the employees #'s. The adjacent sheets "Employee 1, Employee 2...." are individual sheets belonging to a certain employee. Each employee has a certain # of clients. I would like the # of clients to automatically populate from the "employee" sheet onto the "employee stats" sheet. For example, Employee 1 currently has 19 clients which shows in Sheet 2 cell B22. When the # of clients change I would like the information in cell B22 to automatically populate over to Sheet 1 in Cell 4. Therefore I will not have to manually enter the change myself. Am I making sense? I really appreciate your time!

  4. #4
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Index,match function trouble with formula

    The 'Employee Stats' page C4 is the cell that corresponds with Employee 1, February. The first formula is used so that Excel know what day it is. The second formula, which should go in cell C3 and get copied down, uses that information to populate the correct cell. The Indirect/Index/Match portion tells the formula which worksheet (Employee 1, Employee 2, etc) to look at. It will autopopulate already as is.

+ 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