How to Auto Populate a table from Another Worksheet's table

[p_menendez]

Hello, I am carrying out a data analysis and I try to "merge" two of my datasets into one table.

On the one side I have a table with a variable X and a set of attributes (A to D) as in the following:

/	A	B	C	D	X
1	A1	B1	C1	D1	X1
2	A1	B1	C1	D2	X2
3	A2	B1	C2	D3	X3
4	A2	B1	C2	D4	X4
5	A2	B1	C3	D5	X5
6	A3	B1	C3	D6	X6
7	A3	B1	C3	D6	X7
8	A3	B2	C4	D7	X8
n	An	Bn	Cn	Dn	Xn

(In this table the variable X is never repeated, each entry represents a value of X)

On the other side I have another table in other worksheet were the values of variable X are repeated and appear in a different order, and I would like to import their attributes from the first table into the second as in the following:

/	X	A	B	C	D
1	X10	?	?	?	?
2	X7	?	?	?	?
3	X7	?	?	?	?
4	X2	?	?	?	?
5	X5	?	?	?	?
6	X2	?	?	?	?
7	X11	?	?	?	?
8	X7	?	?	?	?
n	X9	?	?	?	?

I researched a little and I guess that the solution may be with a complicate formula resulting from a combination of INDEX and MATCH functions... but I lack the expertise to create it.

Thank you so much in advance!

P.S.: If anyone is interested in the nature of these data, it is a phylogenetic database, X is a list of genra, and A to D are higher taxonomic ranks. The first table is a key to genus and the second is a species list (where I created a collumn with the first word to have a column with all genra).

[Limor_OP]

Hi,
what are the final results that you are eventually expecting to see? is it the 2nd table? if so - how did you get to the numbers?

[p_menendez]

Hello! Thank you so much for your interest, yes it is the second table my expected result. However a friend helped me to figure out how to get to work the INDEX+MATCH formula and it is solved. Thank you anyway!

[Limor_OP]

Great, and glad you figured that out : )