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.
Bookmarks