+ Reply to Thread
Results 1 to 3 of 3

Copy/Paste Index/match Formula

  1. #1
    Registered User
    Join Date
    08-27-2014
    Location
    US
    MS-Off Ver
    2010
    Posts
    2

    Copy/Paste Index/match Formula

    I am trying to copy and past an index/match formula and it will not grab the new reference cells. See attached. I am creating a mileage expense report for employees and would like them to be able to select the origination and destination locations and then the total number of miles will auto populate. I would like them to be able to add rows if need be and just copy the formula down but when I do that it keeps the original origination/destination cells as the reference cells in the formula. I thought adding the $ before/after the cells would work but it does not seem to be doing the trick. Please help. Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Copy/Paste Index/match Formula

    How about:

    Please Login or Register  to view this content.
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    08-27-2014
    Location
    US
    MS-Off Ver
    2010
    Posts
    2

    Re: Copy/Paste Index/match Formula

    It Worked!! You are the best! Thanks so much!!

+ 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: 3
    Last Post: 05-02-2013, 01:31 AM
  2. [SOLVED] Is it possible to use Index match formula to copy whole collum
    By dave1983 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2012, 05:29 PM
  3. [SOLVED] Copy/Paste Index Formula Cells
    By marting in forum Excel General
    Replies: 3
    Last Post: 07-16-2012, 07:01 PM
  4. VLOOKUP INDEX MATCH then copy paste / Link?
    By alleyb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-13-2011, 02:01 PM
  5. copy & increment row +1 w index/match formula
    By cdl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-06-2008, 10:01 AM

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