Index and match exact data

[ganeshm]

Dear Excel users,

I am trying to use index and match formula to gather value of a particular cell. But the formula throws a wrong value.

Kindly review and advice.

 

[Hui]

MATCH(A3,PRAC!C3:I3,0) returns 4 as it should
But the range starts at Column C
whereas the Index Range starts in Column A

So change B3:
=INDEX(PRAC!C3:I10,MATCH(A1,PRAC!A3:A10,0),MATCH(A3,PRAC!C3:I3,0))

or more correctly:
=INDEX(PRAC!$C$3:$I$10,MATCH(A$1,PRAC!$A$3:$A$10,0),MATCH($A3,PRAC!$C$3:$I$3,0))

This allows you to copy it to the other cells as is

 

[ganeshm]

MATCH(A3,PRAC!C3:I3,0) returns 4 as it should
But the range starts at Column C
whereas the Index Range starts in Column A

So change B3:
=INDEX(PRAC!C3:I10,MATCH(A1,PRAC!A3:A10,0),MATCH(A3,PRAC!C3:I3,0))

or more correctly:
=INDEX(PRAC!$C$3:$I$10,MATCH(A$1,PRAC!$A$3:$A$10,0),MATCH($A3,PRAC!$C$3:$I$3,0))

This allows you to copy it to the other cells as is

Thank you..

i realize the mistake now. I didn't select Column C.

Thank you once again.