Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554

Download Excel Start File:
Download Excel Finished File:
Entire page with all Excel Files for All Videos:

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

Excel,Highline College,Mike Girvin,excelisfun,EMT,EMT 1554,VLOOKUP,MATCH,Worksheet Formulas,Power Query M Code,M Code Custom Functions,Table.AddColumn,Table.SelectRows,VLOOKUP Function for two way lookup,Two-Way Lookup,2 way lookup,Power Query Two Way Lookup,List.Last,Record.Field,Power Query Functions,M Code Functions,each Custom Function,Power Query Lookup,