I need to set the following formula on many cells:
This formula looks up the most recent date in the History table, and returns the value specified. Here I'm returning column 7.
How can I paste the cells and auto increment the value where "7" is. In other words I need to paste that summary formula on several hundred cells and change the number 7 for each.