I am working on a grades input spreadsheet.Consider 3 sheets:A list of assessments containing references, names, weighing etc.A list of students, with IDs etc.A table with student names in rows referred from sheet 2; assessment names in columns transposed from sheet 1.Now my problem is that once grades are entered in 3, if sheets 1 or 2 are sorted, the values in sheet 3 do not match with headers anymore.How can I make sure that sorting values in sheet 1 or 2 will keep values in sheet 3 associated with their respective headers?
Google Sheets referenced cells and sorting
google spreadsheets