Results 1 to 3 of 3

Index/Match formula to find multiple data

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2006
    Posts
    62

    Index/Match formula to find multiple data

    I have a list of Stats with a variety of Managers and team members. I've included an example. What I want to do is to type in the month in cell A2 and select the manager in cell B2 and that manager's stats for that month will populate in cell A4:D9 depending on # of team members.

    I have the following formula in cell A8 which will find the 1st team member.
    =INDEX(Stats!$B$2:$F$9,MATCH(1,($A$2=Stats!$A$2:$A$9)*(Team!$B$2=Stats!$C$2:$C$9),0),MATCH(A$3,Stats!$B$1:$F$1,0))

    How or what formula would I be able to use to find the next team member and so on.

    Like I said this is a small sample to a very large database which will grow each month. Any help is greatly appreciated!



    Thanks!
    Attached Files Attached Files
    Last edited by fastballfreddy; 02-06-2010 at 12:12 AM.

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