write the name of the child

[mgm90210M]

this table is contain the data of every child
(with no formula inside that cell) :

cell a1	high	age	iq	grate in history	grate in biology	grate in geography
tomes	6	8	77	77	76	98
stave	7	4	123	65	45	54
brus	3	38	145	98	87	32
dan	7	7	66	65	65	65

<tbody>
</tbody>

i need that when i write the name of the child in second table (in column a )all that data from the first table about that child will write in the second table , like this :

cell a7
tomer	6	8	77	77	76	98
dan	7	7	66	65	65	65

<tbody>
</tbody>

thanks

 

[mgm90210M]

thnks

 

[Aladin Akyurek]

this table is contain the data of every child
(with no formula inside that cell) :

cell a1	high	age	iq	grate in history	grate in biology	grate in geography
tomes	6	8	77	77	76	98
stave	7	4	123	65	45	54
brus	3	38	145	98	87	32
dan	7	7	66	65	65	65

<tbody>
</tbody>

i need that when i write the name of the child in second table (in column a )all that data from the first table about that child will write in the second table , like this :

cell a7
tomer	6	8	77	77	76	98
dan	7	7	66	65	65	65

<tbody>
</tbody>

thanks

	high	age	iq	grade in history	grade in biology	grade in geography
tomes	6	8	77	77	76	98
stave	7	4	123	65	45	54
brus	3	38	145	98	87	32
dan	7	7	66	65	65	65
tomes	6	8	77	77	76	98
dan	7	7	66	65	65	65

<tbody>
</tbody>

A1:G5 is the data with headers.

A7: tomes

B7, just enter, copy across, and down:

=INDEX($B$2:$G$5,MATCH($A7,$A$2:$A$5,0),COLUMNS($B7:B7))

 

[mgm90210M]

anybody please can help me to solve this problem ?

 

[Aladin Akyurek]

anybody please can help me to solve this problem ?

Does post #12 not work you?

https://dl.dropbox.com/u/65698317/aaIndexMatchColumns%20Public%20mgm90210M.xlsx