+ Reply to Thread
Results 1 to 2 of 2

Access a specific element of a cell array

  1. #1
    Registered User
    Join Date
    03-19-2019
    Location
    West Virginia, US
    MS-Off Ver
    Microsoft Excel Office 16
    Posts
    1

    Question Access a specific element of a cell array

    On my sheet there are several user inputs that are fed into a specific table (there are 33) using simple Index(Match())'s depending on the inputs to generate the desired outputs. I have everything set up out to my final outputs and I am stuck. Right now I have an output table of single cell arrays where an example cell contains the function:

    {=INDEX($AD$103:$AD$111,N(IF({1},MATCH(N2:N100,$AC$103:$AC$111,0))))}

    which returns a single column array of {1,2,3...,n}
    Each cell on this table contains unique outputs.

    I need to output a specific element of the array of the desired cell of the output table at an index equal to the input record (i.e.: row 1 returns element 1 of a specific cell of the output table)

    Right now for my output cell I have:

    =INDEX($BR$103:$BR$135,MATCH(R2,$BQ$103:$BQ$135,0))

    which returns the first element of the desired cell on the output table. How can I modify this formula or create a new one that can pull the desired element from the referenced cell?
    The goal here is the not have to store 33(number of tables) * 5(number of desired outputs per record) * 100(number of records) on a cell by cell basis.

    Is this possible? Happy to provide further details.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Access a specific element of a cell array

    Hello dhhamilton0 and Welcome to Excel Forum.
    Perhaps if you could construct and upload a small fictionalized sample of your layout it would help. I'd suggest perhaps 3 tables with 2 desired outputs per record and 4 records.
    Manually include an expected output based on those tables. We may then be able to replicate the output using formulas/code.
    To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 12
    Last Post: 01-14-2014, 01:56 PM
  2. [SOLVED] Returning an array specific to an element of a separate array
    By peterszabla in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-24-2012, 05:30 PM
  3. New to Access - Need to store 420-element array?
    By malkusm in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-25-2012, 02:58 PM
  4. macro to sum all element in array and output it in one cell of excel.
    By mithil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2010, 04:28 PM
  5. Replies: 4
    Last Post: 05-09-2009, 04:45 AM
  6. Can I have an array of arrays and access an element simply?
    By peter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-10-2005, 10:06 AM
  7. UDF to reference a specific element in an array
    By GH in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2005, 12:06 PM

Tags for this Thread

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