I get a spread sheet from other colleagues and compare it to my data. I normally insert columns and then do a index match formula in one cell then drag down the column. I then have to manually edit the formula if I copy it to other columns are not not next to my first column. I've read about offsetting but can't seem to get the formula to work. See attachment and thanks for any advise.
Bookmarks