IF TABLE_1 has data based on TABLE_2, populate in TABLE_3

[surkdidat]

Hi all

In Table_1 I have data, which has a Unique Value in Column A, and data in cells C to Z. (Starting Row 2 downwards). Each of the columns C to Z has a Header

In Table_2 I have the Unique Reference in Column A, and some names of the column headers that are in Table 1.

What I need in table 3 is to replicate table_1, but only include the data if the column header (in Table 2) is listed


TABLE_1

Column A​	Column B​	Column C​	Column D​	Column E​	Column F​
ID_NUMBER​	-	HORSE​	CHICKEN​	FOX​	DOG​
12345	-	XXX		yyy
13579	-	CCC	vvv	eee	WWW
24680	-		hhh	KKK
97531	-	qqq	RRR	UUU	JJJ

TABLE_2

COLUMN A	(Ref Only)	COLUMN B	COLUMN C	COLUMN D	COLUMN E	COLUMN F
ID_NO	No. Of Matches	lookup_1	look_up2	Look_up3	Look_up4	Look_up5
12345	1	HORSE
13579	2	HORSE	DOG
24680	1	FOX
97531	3	CHICKEN	FOX	DOG

END_RESULT

Column A	Column B (Ref OnlY)	Column C	Column D	Colmn E	Column F
ID_NUMBER	No Of Matches	HORSE​	CHICKEN​	FOX​	DOG​
12345	1	XXX		YYY
13579	2	CCC			WWW
24680	1			KKK
97531	3		RRR	UUU	JJJ

So,

For 12345 :-

Table 1 has value is Horse and Fox.
Table 2 wants Horse value only
In Table 1 The value of horse is xxx (Fox would be yyy, but is not needed)

End_Result table should in the cell that crosses Horse and 12345 put xxx only.

I have highlighted in green the values in Table_1 that end up in End_Result Table

 

[Fluff]

Duplicate to: Create Table with cells that contain data in another row for master sheet

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.