Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help with resizing a table array fore using vlookup

    I am having a problem resizing (adding rows) to an existing table array. I have tried many things and none have worked. I don't want to have to redo formulas for the multitude of existing cells that refer to the array. Any help would be appreciated.

    I have tried in both 2007 and 97-03 versions of the program.

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Adding rows to tableArray

    Hi
    Vlookup ..

    Have you tried assigning a range name to the table array.
    eg assign the Name 'Parts' to an array a1:c3
    thus formula becomes
    =vlookup(aCellRef,Parts,aColRef,false)

    When more rows are added to the table array just reassign the same name to the extended array.

    Off 2003: Insert>>Name>>Define
    Off 2010: Formulas Tab>>Name Manager

    Hope this helps

    Geof

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I am not exactly sure what your setup is, but I suspect that you have defined an multi-row array which will not allow new rows to be inserted within it. To get around it, you can eliminate the array, insert the rows and then redefine the array.

    If you need more specifics, you may need to attach a workbook (remove any proprietary information) that has the problem and we can walk through it.

    Steve

  4. #4
    New Lounger
    Join Date
    Mar 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks guys. The solution was a DUH! I guess I couldn't see the forest for the trees.

Posting Permissions

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