Populate table with respect to another table

[Exceltung]

Hi

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]

Table 1​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

Place/Week​

[/td][td]

1​

[/td][td]

2​

[/td][td]

3​

[/td][td]

4​

[/td][td]

5​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

A​

[/td][td]

1​

[/td][td]

2​

[/td][td]

ZZ​

[/td][td]

ZZ​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

B​

[/td][td]

​

[/td][td]

1​

[/td][td]

4​

[/td][td]

​

[/td][td]

3​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

Table 2​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

Place/Week​

[/td][td]

1​

[/td][td]

2​

[/td][td]

Z​

[/td][td]

4​

[/td][td]

5​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

A​

[/td][td]

1​

[/td][td]

2​

[/td][td]

ZZ​

[/td][td]

ZZ​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

A​

[/td][td]

1​

[/td][td]

2​

[/td][td]

ZZ​

[/td][td]

ZZ​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]

B​

[/td][td]

​

[/td][td]

1​

[/td][td]

4​

[/td][td]

​

[/td][td]

3​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td]

B​

[/td][td]

​

[/td][td]

1​

[/td][td]

4​

[/td][td]

​

[/td][td]

3​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]


As shown above, I need to create Table 2 with data from Table 1.
The first column of Table 2 takes reference from the first column of Table 1.
What is the best method to create Table 2?
Thanks in advance.

 

[etaf]

try
=INDEX(C$4:C$6,MATCH($B9,$B$4:$B$6,0))

Book2
	A	B	C	D	E	F	G
1		B	C	D	E	F
2	A
3	1	Table 1
4	2	Place/Week	1	2	3	4	5
5	3	A	1	2	ZZ	ZZ
6	4	B		1	4		3
7	5
8	6	Table 2
9	7	Place/Week	1	2	3	4	5
10	8	A	1	2	ZZ	ZZ
11	9	A	1	2	ZZ	ZZ
12	10	B		1	4		3
13	11	B		1	4		3
14	Sheet: Sheet1
Sheet1

Cell Formulas
Range	Formula
C9:G13	C9	=INDEX(C$4:C$6,MATCH($B9,$B$4:$B$6,0))