13 Nis 2024 ... I want to create a function so that when a student ID (A15) and a year value (B15) is entered, their mark from that year will automatically appear in cell C15.