Say I have the cell A1 which contains the number 13.I want to use that number to refer to a specific cell doing something like ='Items'!CA1 which would mean ='Items'!C13.What is the proper way to write that?
Formula syntax to use a cell data as reference to another cell in a Google spreadsheet
google spreadsheets