# Thread: from a list of 12,251 rows and 317 colomns select a list of 78 rows and 317 colomns Thanks: 0 Likes: 0

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

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
 heading 1 heading 2 heading 3 heading 4 1. S 3 jk 2. D 89 9N 3. V 34 9HJ ..... ... .... ... 482. K 0 7H .... ... .... ... 2009. BN 54 9 .... ..... ... .... 12,251. LO 67 P

table 2 (total of 78 rows)
 heading 1 3. 482. 2009. 8220. 102928.

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
 heading 1 heading 2 heading 3 heading 4 3. V 34 9HJ 482. K 0 7H 2009. BN 54 9 102928. LO 67 P

Thanks for the help!
Amanda

2. ## Re: from a list of 12,251 rows and 317 colomns select a list of 78 rows and 317 colomns

give it a try

ABCDEFGHIJK
1table 1 table 2table 3
31S3jk33V349HJ
42D899N482482K07H
53V349HJ20092009BN549
6...............8220102928LO67P
7482K07H102928
8..............
92009BN549
10................
11102928LO67P

Sheet1

Worksheet Formulas
CellFormula
I3=INDEX(\$A\$2:\$D\$11,MATCH(\$H3,\$A\$2:\$A\$11,0),MATCH(I\$2,\$A\$2:\$D\$2,0))

3. ## Re: from a list of 12,251 rows and 317 colomns select a list of 78 rows and 317 colomns

Thanks AlanY! it works perfectly