Hello everyone,
I have a bunch of formulas that all need to have their columns letter increased each a given number of cells. i.e:
=INDEX(INDIRECT(E4&"!E4:E30"),MATCH(L4,INDIRECT(E4&"!I4:I30"),0))
=MAX(INDIRECT($E4&"!I4"):INDIRECT($E4&"!I30"))
Both those formulas, each 10 rows that the same...