+ Reply to Thread
Results 1 to 7 of 7

Help Copying an Index Array Down Column

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Help Copying an Index Array Down Column

    Hi, I have an index array that works properly in a single cell. How can I copy this down the column so that it calls upon the next row in the table? See example below:

    Formula Entered in column C =(INDEX(A:A,(2)))&(INDEX(B:B,(2)))

    1 A B C
    2 http://help.org/ 2201 http://help.org/2201 (This is correct, and the return I was wanting)
    3 http://help.org/ 1250 (I want to copy the above formula here, but call upon row 3 instead of 2. Is there a way without manually changing the 2 in the formula to 3?)
    4 http://help.org/ 8952
    5 http://help.org/ 3452

    If there is a better formula than the one I used that will accomplish the same result, please let me know. I will be using this for over 8,000 rows! I am not very knowledgeable with excel, excel language or lingo, so please respond as if I understand noting about excel.

    Thanks in advance!

  2. #2
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Help Copying an Index Array Down Column

    Just try this... and copy down...
    =A2&B2

    If you want to keep the hyperlink, then try this...
    =HYPERLINK(A2&B2)
    Last edited by djapigo; 01-11-2013 at 02:26 PM.

  3. #3
    Registered User
    Join Date
    01-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Help Copying an Index Array Down Column

    Haha, Thanks! That is far more similar, I was trying to make it way more complicated. Thanks again!

  4. #4
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Help Copying an Index Array Down Column

    Glad it works for you...

    To mark your thread solved do the following:
    - Go to the first post
    - Click edit
    - Click Advance
    - Just below the word "Title:" you will see a dropdown with the word No prefix.
    - Change to Solve
    - Click Save

  5. #5
    Registered User
    Join Date
    01-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Help Copying an Index Array Down Column

    I am trying to mark it as solved, but when I click advanced it logs me out preventing the advanced screen to appear. Any advice?

  6. #6
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Help Copying an Index Array Down Column

    Yikes, that's beyond me... moderators, any ideas?

  7. #7
    Registered User
    Join Date
    01-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Help Copying an Index Array Down Column

    I had to change browsers, reset, close, and reopen, but I got it to work! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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