Results 1 to 6 of 6

attempting to dynamically define table with index

Threaded View

  1. #1
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    attempting to dynamically define table with index

    ....i'm almost there...think i'm missing something simple here but been at this for awhile now and would like some help.

    Basically, I would like to replace the 4:8 in this statement with a dynamic range....users will be adding rows above and growing the curent table and I want the calculations on row 17 (attached document) to adjust for a moving/growing table.


    =INDEX(4:8,MATCH(B17,INDEX(4:8,,12),1),10)+(B17-INDEX(4:8,MATCH(B17,INDEX(4:8,,12),1),12))*G11

    I've tried the following:
    INDEX((MATCH(">>begin<<",B:B,0)+2) : (MATCH(">>end<<",B:B,0)-1),MATCH(B17,INDEX(4:8,,12),1),10)+(B17-INDEX(4:8,MATCH(B17,INDEX(4:8,,12),1),12))*G11

    Basically i've sanwiched the table between two markers (>>begin<< and >>end<<) and i'm trying to use match to find the markers to dynamically define the tables rows...

    any help out there?
    Attached Files Attached Files
    Last edited by GeneralDisarray; 10-21-2011 at 04:34 PM.
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

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