Lookup Values with Merge | Power Query | Excel Off The Grid

Описание к видео Lookup Values with Merge | Power Query | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy



★ Check out the blog post & download the example file★
https://exceloffthegrid.com/power-que...


★ About this video ★
Looking up data from a table or worksheet is probably the most common activity undertaken by Excel users to create reports. Learning to use VLOOKUP for many is their first taste of Excel’s power. But what about when using Power Query? There isn’t a VLOOKUP function, so how can we lookup a value from another table with Power Query? Well… in Power Query, we use the merge transformation.


0:00 Introduction
0:50 Types of lookup
1:46 Scenario
2:40 Lookup value with exact match
6:23 Lookup value with approximate match
11:15 Multiple matches
13:16 Multiple criteria
14:37 Conclusion


★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/



★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com

Twitter:   / exceloffthegrid  


#MsExcel #PowerQuery

Комментарии

Информация по комментариям в разработке