Lookup Two Tables to Bring Back Matches in Both

🔔 SUBSCRIBE to my channel ➜


This video will cover the INNER JOIN merge capability in Excel Power Query. This type of join returns records from two reference tables that have matching values in both tables. We are basically looking for matching records from two tables and only those records that have a common field ( or key) are brought back in a results table. In INNER JOIN comes from SQL and it's among the different join types available. It's nice that it comes with Power Query so you don't need a fancy database like Oracle, SQL Server or MySQL.



#exceltutorial
#doughexcel


🏫 Excel Training ➜

📚 Excel Books & Tech Gear ➜

⚙️ Tools I Use: Screencasting ➜

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

dough,microsoft,tips,tricks,tutorial,training,msoffice,101,easy,simple,learn,windows,basic,how-to,how,to,how to,chart,charts,graphs,doug h,doughexcel,doug h excel,create,make,excel function,excel formula,excel chart,excel dashboard,excel,powerpoint,data,analyze,advanced,free,formulas,download,online,xls,vlookup,top channel,