Questions Tags Users Badges

I have student-subject-marks table and i want to achieve the result present in the second table. marks should not be the hard coded

Dharmesh Singh 0

Created Sep 7, 2022 Edited Sep 7, 2022

Viewed 17

This table is given

This table is given

I want to achieve the results as shown in result table, marks should not be hard coded

I want to achieve the results as shown in result table, marks should not be hard coded

google-sheets-formula google-sheets

1 Answers

use:

=INDEX(IFNA(VLOOKUP(C2:C&E1:G1, {I2:I&J2:J, K2:K}, 2, )))

edited Sep 7, 2022

player00

answered Sep 7, 2022

Related