+ Reply to Thread
Results 1 to 4 of 4

Help with Index, Match, and Offset Forumla

  1. #1
    Registered User
    Join Date
    03-25-2011
    Location
    San Diego
    MS-Off Ver
    Excel 2003
    Posts
    6

    Help with Index, Match, and Offset Forumla

    Hey everyone, I am in desperate need of some help with this pipeline report that I am trying to create. Everything that is needed should be in the attached document. Just a bit of warning though, this should be attempted by advanced excel users.

    The work on the left is my current progress, and the work on the right is what the finished product should look like. As I say in the document, if you can help me with the client (target) tab I will be very thankful!

    Thanks for any help you can give me!
    Attached Files Attached Files
    Last edited by tjohn909; 03-25-2011 at 08:35 PM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Help with Index, Match, and Offset Forumla

    Hello, you could do that with a pivot table. See attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-25-2011
    Location
    San Diego
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Help with Index, Match, and Offset Forumla

    bump
    Thanks for the pivot table suggestion but I'm trying to generate a report how it looks like on the report tab on the right using the data on the data tab.

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Help with Index, Match, and Offset Forumla

    You won't be able to do that with formulas. You'd need VBA to do that. I don't know enough VBA to achieve that, but I don't quite see the point of doing something with VBA that can be done with Excel natively.

+ 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