Hello forum users and Gurus!!!
I am trying to us the Index formula in Excel 2010 and I have a table with a large array of columns. Instead of going into each cell and modify the column reference in 149 cells, I was trying to see if there is a formula or modification to the Index formula so I can drag across the row and the column reference increments accordingly.
This is the basic formula I am using...
Formula:Please Login or Register to view this content.
If I drag this formula across the row, the column reference does not change.