The formula =INDIRECT(MID(CELL("address",C3),2,1)&CELl("row",D6)) uses the INDIRECT function to indirectly reference another cell.
What does the function do?
The MID function is being used to extract a specific character from the address of the cell referenced by CELL("address",C3).
The & operator is being used to concatenate the extracted character with the row number of the cell referenced by CELL("row",D6). The resulting string is then being passed to the INDIRECT function, which evaluates it as a cell referenc