Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2016
    Thanked 0 Times in 0 Posts

    Array Formula only returns value of first incident?

    I'm obviously doing something wrong, but I'm at a loss. The file in question is attached. I'm simply trying to return the values for the field identified as constructFK using an index from the table "Constructs", lookup values from the table "CellAssays" and lookup arrays in "Constructs". All I am seeing is the constructFK for the very first hit. Help greatly appreciated.

    Edit: And I'm already back having found the solution. I simply replaced the original array with the formula below and all is good:

    This was the original formula:

    {=INDEX(Constructs[ConstructPK],MATCH([Fusion Partner]&[Kinase]&[Allele],Constructs[Fusion Partner]&Constructs[Kinase]&Constructs[Allele],0))}

    And this is the corrected version:

    {=INDEX(Constructs[ConstructPK],MATCH(F2&G2&H2,Constructs[Fusion Partner]&Constructs[Kinase]&Constructs[Allele],0))}

    Clearly I still have something to learn about the behavior of tables. Sorry to have been a bother.
    Last edited by SD David; 2016-06-18 at 20:30. Reason: Found Solution

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Thanked 1,125 Times in 1,048 Posts
    You can mark the solution solved by clicking on the Solved button at the bottom.

    cheers, Paul

Posting Permissions

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