CODEWITHSUNDEEP
excelexcel-formula
suj
suj

Reputation: 11

How to calculate the marks of selected student and subject dynamically in excel?

I am not able to calculate marks of particular student based on particular subject (both student name and subject are as dropdown list) from another table.

Here is how table looks like:
enter image description here

Upvotes: 0

Views: 735

Answers (1)

Harun24hr
Harun24hr

Reputation: 36965

INDEX()/MATCH() can give you expected result. Try-

=INDEX(B3:D7,MATCH(F3,A3:A7,0),MATCH(G3,B2:D2,0))

enter image description here

Upvotes: 1

Related Questions