to get the relative marks from a table of names,subjects & marks?
 

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

to get the relative marks from a table of names,subjects & marks?
 

Try the formula
b13=index($a$1:$g$11,match($a13,$a$2:$a$11,),match (b$12,$a$1:$g$1,))
a13 = Name of the student
where a12:g12 heading viz name, subjects
Just copy the formula from b13:g13
with regards
sreedhar



"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

to get the relative marks from a table of names,subjects & marks?
 

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