I am using index match to point to a particular cell on a page. When I copy the formula down however it is just copying the base formula and not automatically pointing to the next row down. I have like 150 cells to reference and changing the row number for each formula will be a pain. Is there a way to automatically add 1 to the row number when copying an index match formula down?
Bookmarks