I am confused by what that formula is trying to do. Is A2&"C9" meant to be a range that is bounded by a cell string in C9?

Can you give an example of the data?