Perform a Lookup with Power Query
This video show how to use Power Query to perform lookups. For small data sets you are better off with Excel's other lookup function, but if you are dealing with large data sets (over half a million) you may be better off using Power Query. This method also would make it easier if you do this on a recurring basis (daily, weekly, etc) and didn't/couldn't write macros.
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101
📝 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!
🎁 If you find these videos useful and want to support my channel go to https://www.patreon.com/DoughExcel
#excel
#msexcel
#doughexcel
Видео Perform a Lookup with Power Query канала Doug H
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101
📝 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!
🎁 If you find these videos useful and want to support my channel go to https://www.patreon.com/DoughExcel
#excel
#msexcel
#doughexcel
Видео Perform a Lookup with Power Query канала Doug H
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554How Power Query Will Change the Way You Use ExcelGrouping Data with Power QueryCreate a Many to Many Relationship Model in Power PivotGet Multiple Files Containing Multiple Sheets with Power QueryExcel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query)How to use Microsoft Power QueryCombine Tables from Multiple Sheets in the Same Workbook with Power QueryIdentify Duplicate Values in a Table with Power QueryReturn Multiple Match Results in Excel (2 methods)35 Cross Filter Selection and Many To Many Relationships | Power BI | SpeedilytechExcel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract RecordsQuick Vlookups in Power Query!The New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in ExcelMSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, MoreHow to easily automate boring Excel tasks with Power Query!How to use Microsoft Power BI - Tutorial for BeginnersExcel for Accountants: Power Query & PivotTables to Import & Clean Data and Build ReportsMake it Easier to Share Power Query Relative File Location (XLSX source)Import Multiple Pages from Web with One Query in Excel