Table 1
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]Pre-planning[/TD]
[TD]x[/TD]
[TD]X[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]Plan[/TD]
[TD]
[/TD]
[TD]x[/TD]
[TD]X[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]Config & Pro[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Title[/TD]
[TD]Level[/TD]
[TD]Oganization[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]Project Management Team[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Project Lead[/TD]
[TD]Directory[/TD]
[TD]Company[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Testing lead[/TD]
[TD]Manager[/TD]
[TD]Client[/TD]
[TD]
[/TD]
[TD].50[/TD]
[TD]1.00[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]Finanical Functional Team[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Project Support Analyst[/TD]
[TD]Analyst[/TD]
[TD]Client[/TD]
[TD][/TD]
[TD][/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Testing Support Analyst[/TD]
[TD]Principal Consultant[/TD]
[TD]Company[/TD]
[TD]
[/TD]
[TD]1.00[/TD]
[TD][/TD]
[TD]1.00[/TD]
[/TR]
</tbody>[/TABLE]
For the Table 1 provided above, I need a formula for:
Table2
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]Pre-Planning[/TD]
[TD]Project Management Team[/TD]
[TD]Project lead[/TD]
[TD]Director[/TD]
[TD]Company[/TD]
[/TR]
[TR]
[TD]Pre-Planning[/TD]
[TD]Project Management Team[/TD]
[TD]Testing lead[/TD]
[TD]Manager[/TD]
[TD]Client[/TD]
[/TR]
[TR]
[TD]Pre-Planning[/TD]
[TD]Financial Functional Team[/TD]
[TD]Testing Support Analyst[/TD]
[TD]Principal Consultant[/TD]
[TD]Company[/TD]
[/TR]
[TR]
[TD]Plan[/TD]
[TD]Project Management Team[/TD]
[TD]Testing Lead[/TD]
[TD]Manager[/TD]
[TD]Client[/TD]
[/TR]
[TR]
[TD]Plan[/TD]
[TD]Financial Functional Team[/TD]
[TD]Project Support Analyst[/TD]
[TD]Analyst[/TD]
[TD]Client[/TD]
[/TR]
[TR]
[TD]Config & Pro[/TD]
[TD]Finanaical Functional Team[/TD]
[TD]Proejct Support Analyst[/TD]
[TD]Analyst[/TD]
[TD]Client[/TD]
[/TR]
[TR]
[TD]Config& Pro[/TD]
[TD]Testing Support Principal[/TD]
[TD]Testing SupportAnalystt[/TD]
[TD]Principal Consultant[/TD]
[TD]Company[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]Pre-planning[/TD]
[TD]x[/TD]
[TD]X[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]Plan[/TD]
[TD]
[/TD]
[TD]x[/TD]
[TD]X[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]Config & Pro[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Title[/TD]
[TD]Level[/TD]
[TD]Oganization[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]Project Management Team[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Project Lead[/TD]
[TD]Directory[/TD]
[TD]Company[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Testing lead[/TD]
[TD]Manager[/TD]
[TD]Client[/TD]
[TD]
[/TD]
[TD].50[/TD]
[TD]1.00[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]Finanical Functional Team[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Project Support Analyst[/TD]
[TD]Analyst[/TD]
[TD]Client[/TD]
[TD][/TD]
[TD][/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Testing Support Analyst[/TD]
[TD]Principal Consultant[/TD]
[TD]Company[/TD]
[TD]
[/TD]
[TD]1.00[/TD]
[TD][/TD]
[TD]1.00[/TD]
[/TR]
</tbody>[/TABLE]
For the Table 1 provided above, I need a formula for:
- Rows 1-3: Use the X's in columns D-G to index Column C
- Use the X's to pull in the data below (blue/orange), need it automated to look like the table 2 below.
Table2
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]Pre-Planning[/TD]
[TD]Project Management Team[/TD]
[TD]Project lead[/TD]
[TD]Director[/TD]
[TD]Company[/TD]
[/TR]
[TR]
[TD]Pre-Planning[/TD]
[TD]Project Management Team[/TD]
[TD]Testing lead[/TD]
[TD]Manager[/TD]
[TD]Client[/TD]
[/TR]
[TR]
[TD]Pre-Planning[/TD]
[TD]Financial Functional Team[/TD]
[TD]Testing Support Analyst[/TD]
[TD]Principal Consultant[/TD]
[TD]Company[/TD]
[/TR]
[TR]
[TD]Plan[/TD]
[TD]Project Management Team[/TD]
[TD]Testing Lead[/TD]
[TD]Manager[/TD]
[TD]Client[/TD]
[/TR]
[TR]
[TD]Plan[/TD]
[TD]Financial Functional Team[/TD]
[TD]Project Support Analyst[/TD]
[TD]Analyst[/TD]
[TD]Client[/TD]
[/TR]
[TR]
[TD]Config & Pro[/TD]
[TD]Finanaical Functional Team[/TD]
[TD]Proejct Support Analyst[/TD]
[TD]Analyst[/TD]
[TD]Client[/TD]
[/TR]
[TR]
[TD]Config& Pro[/TD]
[TD]Testing Support Principal[/TD]
[TD]Testing SupportAnalystt[/TD]
[TD]Principal Consultant[/TD]
[TD]Company[/TD]
[/TR]
</tbody>[/TABLE]