A mistake in the range
b13=index($a$1:$g$11,match($a13,$a$1:$a$11,),match (b$12,$a$1:$g$1,))
with regards
Sreedhr
"kswarrier" wrote:

hi,
I have a table containing the marks of 10 students for 6 subjects .How to
get the marks of a student for a subject by using an easy formula, if names
are in cells a2:a11,subjects are in cells b1:g1 and marks in cells b2:g11.
thanks in advance