# HOW TO MATCH "HSN CODE" AFTER PULL DATA ON DIFFRENT-DIFFRENT TABLE ???

[krunal123]

# HOW TO MATCH "HSN CODE" AFTER PULL DATA ON DIFFERENT-DIFFERENT TABLES ???

We need pull data into different- different Table .

Kindly Help on solve my Query, Kindly Send us Proper formula ,

- perfect match " HSN CODE" And pull data from TABLE1 , send to matching table

 

[Peter_SSs]

We cannot copy from a picture so my sample data is different & minimal. Here is result for one table. Formula for the others is similar structure.

krunal123.xlsm
	A	B	C	D	E	F	G
1
2	HSN CODE	PRODUCTS	RATE		ASSORTED	HSN CODE	RATE
3	12345	Prod 1	1		Prod 3	12347	3
4	12347	Prod 2	2		Prod 1	12345	1
5	12347	Prod 3	3		Prod 1	12348	#N/A
6	12348	Prod 4	4
7	12345	Prod 5	5
8
Sheet1

Cell Formulas
Range	Formula
G3:G5	G3	=FILTER(TABLE1[RATE],(TABLE1[HSN CODE]=[@[HSN CODE]])*(TABLE1[PRODUCTS]=[@ASSORTED]),NA())