Hey everyone,

I am looking to copy an index match formula down but want the two array ranges to skip 22 rows for each row I copy down. I'm not sure whether there is a way to skip cells, or if the true answer is imbedding another index match formula within the first to first find which table the arrays are in, but was just looking for some guidance.

I have attached a file for reference. In the attached, I am trying to copy down the yellow cells in the "Assumptions" worksheet. The arrays in the index, match formula should increase by 22 each time.

Also note, that in the source arrays, there is a unique asset name which is repeated on both tabs. Maybe this is what I should be looking for to find the table?

Thanks,
B

Excel_Help_M1.xlsx