How to use dropdown list according Two or more different Tables ???

[krunal123]

Query : " HOW TO COMBINE " ITEMLIST " & USE
IN DROPDOWN LIST (Condition : Inclued Both table "Item list"


* Both Table "Item list is different *



BOTH TABLE ITEM LIST SHOW ON MY DROP-DOWN LIST .

HOW IT POSSIBLE THIS ????? KINDLY SUGGEST RIGHT WAY TO SOLVE THIS QUERY.

Note: I was make Copy All Item list in Different tables & make Single list , But this work is time wasted , So Suggest Easy Way .

 

[Fluff]

How many rows of data do you actually have in those two tables?

 

[Fluff]

Assuming the tables are fairly small how about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I
1
2		Item Name		Item Name			West Yorkshire		Devon
3		West Yorkshire		High Peak			Derbyshire
4		Derbyshire		Bradford			Lancashire
5		West Yorkshire		Derbyshire Dales			County Durham
6		West Yorkshire		Bradford			Devon
7		Lancashire		Kirklees			North Yorkshire
8		West Yorkshire		Rossendale			South Yorkshire
9		County Durham		Kirklees			Staffordshire
10		Devon		County Durham			High Peak
11		County Durham		Teignbridge			Bradford
12		North Yorkshire		County Durham			Derbyshire Dales
13		West Yorkshire		Richmondshire			Kirklees
14		South Yorkshire		Bradford			Rossendale
15		Staffordshire					Teignbridge
16		North Yorkshire					Richmondshire
17		West Yorkshire
18
Main

Cell Formulas
Range	Formula
G2:G16	G2	=UNIQUE(FILTERXML("<k><m>"&TEXTJOIN("</m><m>",,Table1[Item Name],Table2[Item Name])&"</m></k>","//m"))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
I2	List	=G2#

 

[krunal123]

A big Problem face "Joint Different -Different Table "

My list Include Name with value : RICE (1 KG X 25 PKT)



HOW TO SOLVE THIS QUERY ????????????????????????????????????????????????????????????????

 

[Fluff]

How many rows of data do you have in each table?