Results 1 to 10 of 10

dynamic index match formula to transpose values across rows and then down columns

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2013
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2013
    Posts
    21

    dynamic index match formula to transpose values across rows and then down columns

    Hello all. So I have a very tricky formula that I just can't seem to get; I'm a bit of a dabbler in excel and am afraid I just don't have what it takes to figure this one out.

    I've attached a file, & here's what I need it to do:
    Depending on which value (0-14, located in a2:a16) I input into k1, transpose the numbers from the matrix a1:g29 into K2:K34, reading across the rows, and then down from the last position in g. It's a bit confusing,so I tried to highlight the direction in which i want it to read, but column g will read down from different numbers. I put examples of what I would want 0 as the input to read like in L2, and what 1 as the input should read like in M2. I understand that the number of rows would be less for higher numbers input into k1, so I also have an iferror added in there. I've got the first cell formula correct in k2, but that's all I can get. If anyone can help it would be so appreciated! Thanks for looking!

    ~Laura
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sumproduct or index match dynamic formula
    By jw01 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-18-2013, 07:54 PM
  2. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  3. Increment columns in INDEX and MATCH formula - ROWS and COLUMNS
    By nickmangan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2012, 10:38 AM
  4. Manipulate dynamic rows values and dynamic columns values
    By excel_vb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2010, 09:22 PM
  5. dynamic range for index/match formula
    By excellicious in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-29-2008, 07:41 PM

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