Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Angry Unanswered: Cross Table with Values, Index Match?

    Hello

    Assistance with this exercise would be kindly appreciated.

    I tried using a few variatons of Index>Match but couldn't quite get it to work.

    I would start Sheet 2 with a list of all the stocks on the left and the fund names on the top. Then I need to populate...

    Thanks!
    Attached Thumbnails Attached Thumbnails Excel Example.png  

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    I'm not 100% sure how you're trying to get from one to the other in Excel, but with careful use of IF() and ISERROR()/ISNULL(), you could probably get it to work:
    Code:
    =IF([ISERROR({Match+index/Vlookup expression})/ISNULL({Match+index/Vlookup expression})], "Not Held", {Match+index/Vlookup expression})
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  3. #3
    Join Date
    Mar 2009
    Posts
    2
    Ignoring the "not held," aspect -- whats an effective way to change it from the list format into the cross-table (name?) format?

  4. #4
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    Turn it into a pivot table (Data -> Pivot Table and Pivot Chart Report...).

    I don't use them at all, but they work like an interactive cross-tab query.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •