Hi members of excel forum..
I have an index-match formula in a cell of one table.
I want to fill the rows below that cell by using the formula of that cell (which is the index-match formula).
By dragging down the cell, as we know the below cells will be filled automatically jumping one row respectively.
However, my goal is to fill the below cells by a reference range that jumped several number of rows (8 to be precise).
For easier understanding, I attach the example sheet (pls see the comment box).
Thank you very much for your attention and assistance.
Bookmarks