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

[kswarrier]

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
(e-mail address removed)

 

[yshridhar]

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

 

[yshridhar]

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