Try this function for Google Sheets to convert a text string into a cell reference. When you need to construct not type your formula, use INDIRECT
Scooped by
Tom D'Amico (@TDOttawa)
onto iGeneration - 21st Century Education (Pedagogy & Digital Innovation) |