Download Excel Start File: excelisfun.net/files/EMT1554Start.xlsx
Download Excel Finished File: excelisfun.net/files/EMT1554Finished.xlsx
Entire page with all Excel Files for All Videos: excelisfun.net/files/
In this video learn how to create Power Query M Code formulas for Exact Match and Approximate Match Two Way Lookup.
Topics:
1. (00:06) Introduction
2. (00:40) Exact and Approximate Match Lookup
3. (01:44) Worksheet Exact Match Two-Way Lookup with VLOOKUP & MATCH functions.
4. (04:11) Power Query Exact Match Two-Way Lookup using M Code formulas. Learn M Code Syntax for looking up a Record. Use the Record.Field Function.
5. (10:40) Worksheet Approximate Match Two-Way Lookup using an Array Formula with VLOOKUP & MATCH functions.
6. (13:25) Power Query Approximate Match Two-Way Lookup using M Code formulas. Learn about Custom Functions. Use the Table.AddColumn, Table.SelectRows and List.Last Functions. Learn syntax for Custom Functions, including the each keyword for Custom Functions or explicitly defined M Code Custom Functions. Learn how to create formulas with back to back custom functions.
7. (20:55) Summary
- Two-Way Lookup in Power Query M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554 ( Download)
- Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747 ( Download)
- Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810 ( Download)
- VLOOKUP in Power Query Using List Functions ( Download)
- VLOOKUP Approximate Match in Power Query: Binning & Column by Example ( Download)
- Power Query Approximate Match VLOOKUP ( Download)
- Power Query: Lookup 3 Lowest Prices from 3 Criteria Lookup Table. Excel Magic Trick 1738. ( Download)
- Power Query Get Previous Row Stock Price Change Formula. M Code Lookup. Excel Magic Trick 1546 ( Download)
- Perform an Approximate Lookup with Power Query ( Download)
- LOOKUP VALUE WITH MULTIPLE CRITERIA IN POWER BI | 2 WAY LOOKUP FORMULA IN POWER QUERY AND POWER BI ( Download)
- Approximate Match VLOOKUP with Power BI and Power Query ( Download)
- Use Conditions in Power Query for an Approximate Match Lookup ( Download)
- Lookup Values in the Same Table with Power Query M ( Download)
- DAX Approximate Match Lookup Part 2: Foreign Key & Relationship or LOOKUPVALUE EMT1492 ( Download)
- Excel - Match Closest Partial, Misspelled Text Value - Fuzzy Match Lookup in Power Query ( Download)
