from a list of 12,251 rows and 317 colomns select a list of 78 rows and 317 colomns

[AmandaSS]

Dear all,

I have a spread sheet with a list of 12,251 rows and 317 columns. Then I have another list of 78 rows and 2 columns.
The two lists have the first column in common, as below

table 1
[TABLE="width: 500"]
<tbody>[TR]
[TD]heading 1[/TD]
[TD]heading 2[/TD]
[TD]heading 3[/TD]
[TD]heading 4[/TD]
[/TR]
[TR]
[TD]1.[/TD]
[TD]S[/TD]
[TD]3[/TD]
[TD]jk[/TD]
[/TR]
[TR]
[TD]2.[/TD]
[TD]D[/TD]
[TD]89[/TD]
[TD]9N[/TD]
[/TR]
[TR]
[TD]3.[/TD]
[TD]V[/TD]
[TD]34[/TD]
[TD]9HJ[/TD]
[/TR]
[TR]
[TD].....[/TD]
[TD]...[/TD]
[TD]....[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]482.[/TD]
[TD]K[/TD]
[TD]0[/TD]
[TD]7H[/TD]
[/TR]
[TR]
[TD]....[/TD]
[TD]...[/TD]
[TD]....[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]2009.[/TD]
[TD]BN[/TD]
[TD]54[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]....[/TD]
[TD].....[/TD]
[TD]...[/TD]
[TD]....[/TD]
[/TR]
[TR]
[TD]12,251.[/TD]
[TD]LO[/TD]
[TD]67[/TD]
[TD]P[/TD]
[/TR]
</tbody>[/TABLE]

table 2 (total of 78 rows)
[TABLE="width: 500"]
<tbody>[TR]
[TD]heading 1[/TD]
[/TR]
[TR]
[TD]3.[/TD]
[/TR]
[TR]
[TD]482.[/TD]
[/TR]
[TR]
[TD]2009.[/TD]
[/TR]
[TR]
[TD]8220.[/TD]
[/TR]
[TR]
[TD]102928.[/TD]
[/TR]
</tbody>[/TABLE]

I need to create a new table (3) made of the 78 rows of table 2 and the corresponding 317 columns taken from table 1.

table 3
[TABLE="width: 500"]
<tbody>[TR]
[TD]heading 1[/TD]
[TD]heading 2[/TD]
[TD]heading 3[/TD]
[TD]heading 4[/TD]
[/TR]
[TR]
[TD]3.[/TD]
[TD]V[/TD]
[TD]34[/TD]
[TD]9HJ[/TD]
[/TR]
[TR]
[TD]482.
[/TD]
[TD]K[/TD]
[TD]0[/TD]
[TD]7H[/TD]
[/TR]
[TR]
[TD]2009.[/TD]
[TD]BN[/TD]
[TD]54[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]102928.[/TD]
[TD]LO[/TD]
[TD]67[/TD]
[TD]P[/TD]
[/TR]
</tbody>[/TABLE]

Thanks for the help!
Amanda

 

[AlanY]

give it a try

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	table 1					table 2		table 3
2	heading 1	heading 2	heading 3	heading 4		heading 1		heading 1	heading 2	heading 3	heading 4
3	1	S	3	jk		3		3	V	34	9HJ
4	2	D	89	9N		482		482	K	0	7H
5	3	V	34	9HJ		2009		2009	BN	54	9
6	.....	...	....	...		8220		102928	LO	67	P
7	482	K	0	7H		102928
8	....	...	....	...
9	2009	BN	54	9
10	....	.....	...	....
11	102928	LO	67	P
Sheet1

Cell Formulas
Range	Formula
I3	=INDEX($A$2:$D$11,MATCH($H3,$A$2:$A$11,0),MATCH(I$2,$A$2:$D$2,0))

 

[AmandaSS]

Thanks AlanY! it works perfectly