+ Reply to Thread
Results 1 to 5 of 5

return multiple columns/rows of data in formula?

  1. #1
    Registered User
    Join Date
    11-10-2007
    Posts
    2

    return multiple columns/rows of data in formula?

    I'm trying to write a formula that will return multiple rows of data by selecting a name from a drop down list. This page is really a summary section of the yearly data. I have all the data organized (below) that i want to summerize but cant get each row to populate. With vlookup i get just the top row of each person, i need all 5 rows. To many if's to write in 1 statement, index/match - could get it to work.

    i made a shell of the same format of column titles with a name drop list so Say i select name Sam. I want all of is data to populate like listed below.

    Looks like this but continues for about 20 reps over the full 12 months.

    row 1 > rep a name, type, jan, feb, mar, etc..,
    joe fax 1, 1, 1,
    call 3, 2, 1,
    email 1, 1, 1,
    etc
    etc
    sam fax ............................
    call
    email
    etc
    etc
    karen continues


    Am i just crazy?

  2. #2
    Forum Contributor
    Join Date
    10-30-2007
    Location
    Norway
    MS-Off Ver
    MS Office 2007
    Posts
    345
    This sounds like it is possible to do, but I would need a sheet with sample data and a template of how you want your result to look like, to be able to help you. Could you upload this in a .zip file ?

  3. #3
    Registered User
    Join Date
    11-10-2007
    Posts
    2

    sample of the challange

    Here is a zip of what i'm looking to do. Possible?
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    10-30-2007
    Location
    Norway
    MS-Off Ver
    MS Office 2007
    Posts
    345
    You can use a combination of OFFSET and MATCH. I think you can do it with INDEX and MATCH too with some relative adressing.
    Se example in attachment

  5. #5
    Forum Contributor
    Join Date
    10-30-2007
    Location
    Norway
    MS-Off Ver
    MS Office 2007
    Posts
    345
    .... with attachment
    Attached Files Attached Files

+ 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