Query a file based on a table, return results

[Richard U]

Sorry if this is simple, I am trying to teach myself power query and am not at all familiar with M

On the sheet, I have a list, and want to match it against a file and pull the rows that match the list.

The table I would be pulling would be like this

Stop	Final	INV	Package
NYC	NYC	5551212​	JLO465
NYC	DFW	5551212​	UIR131
NWK	NWK	4445566​	NNY333
NWK	DFW	JJT331	NNY333
LAX	DFW	9995544​	NVT142
LAX	GJT	9981431​	NN376
GJT	GJT	1112213​	WNY114
GJT	GJT	1112213​	WNY114
DFW	DFW	8884454​	JJT331
DFW	GJT	8884454​	JJT331
CAK	CAK	5551212​	JJT331
OKC	DFW	JJT331	WNY114

The matching table would be something like this

Locations

NYC

NWK

LAX

GJT

DEN

DFW

JFK

ABQ

OKC

Stop	Final	INV	Package
NYC	NYC	5551212​	JLO465
NYC	DFW	5551212​	UIR131
NWK	NWK	4445566​	NNY333
NWK	DFW	6675452​	NNY333
LAX	DFW	9995544​	NVT142
LAX	GJT	9981431​	NN376
GJT	GJT	1112213​	WNY114
GJT	GJT	1112213​	WNY114
DFW	DFW	8884454​	JJT331
DFW	GJT	8884454​	JJT331

The "Locations" would be in the importing spreadsheet, and the other table would be in a different file.

How would I query one against the other to get a results table that would only include locations in the matched table?

If someone can get me as far as the way to structure the query, I could probably figure it out from there

 

[Richard U]

It's explained well here.... Posting this in case anyone else has the same question:

Join two or more tables in Excel with Power Query

Need to analyze a lot of data scattered across many worksheets in Excel? Join tables by matching one or more columns with Power Query or Merge Tables Wizard.

www.ablebits.com