Now my columns can change depending on certain parameters, so I need to select column J instead. Now, how do I replace the part G:G with a dynamic formula which can fill other column names. So lets say in a certain cell (G20) I get the mentioned first cell in column J as $J$30, then I am using this formula to extract the column name =char(column(indirect(G20))+64) to get the alphabet J. When I use this formula in the above index formula, its not selecting the entire column J. Can someone guide me how to do this