Perform a Two Column Lookup with Power Query - - vimore.org

Perform a Two Column Lookup with Power Query

Perform a Two Column Lookup with Power Query

YouTube

Check out my Blog: http://exceltraining101.blogspot.com If you worked with lookup functions like VLOOKUP or INDEX/MATCH, you now it can't natively perform multiple column lookups unless you add a helper column that concatenates values. Or you can do this concatenation within the function iteself and use the Ctrl-Shift-Enter key to enter it as an array function. Of course in Excel there are many ways to do the same thing and this is one of those video that will give you another option to do a two column or two way lookup with Power Query capabilities in Excel. Check it out! If you want to see how it's done with Excel functions here's another video https://www.youtube.com/watch?v=_MP0jDs8XtU P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel #excel101 --------------------- Excel Training: https://www.exceltraining101.com/p/training.html Excel Books: https://www.amazon.com/shop/dough



Perform a Lookup with Power Query

Check out my Blog: http://exceltraining101.blogspot.com This video show how to use Power Query to perform lookups. For small data sets you are better off with

YouTube

Power Query: Index and Modulo Functions

Power Query's Index and Modulo functions help us tackle those pesky multi-row reports.

YouTube

Pivot Table with Progress Chart and Dashboard

In this Training Video I'll show you how to create a Pivot Table in Excel with dynamic Progress Doughnut Chart and a Dashboard. Impressive result with an easy t

YouTube

Compare Two Lists Using the Vlookup Formula

https://www.udemy.com/excel-2010-superhero-course/?couponCode=Excel2010YouTube Compare two lists using the VLOOKUP formula in Excel. Use the VLOOKUP function t

YouTube

DAX Fridays! #37: SELECTCOLUMNS

In todays video we will go through the SELECTCOLUMNS function in DAX. Link to pbi file: https://curbal.com/blog/glossary/selectcolumns-dax ‎ EXCEL SURVEY: ht

YouTube

Grouping Dates in a Pivot Table

Check out my Blog: http://exceltraining101.blogspot.com Pivot Tables are a fantastic tool to do analysis and one of the things you can do is to group row fiel

YouTube

Return Multiple Match Results in Excel (2 methods)

Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Quickly learn how to lookup one value in Excel and return multiple matc

YouTube

Create a Basic Custom Function in Power Query

Check out my Blog: http://exceltraining101.blogspot.com Creating a Custom Function in Power Query is actually a simple process. Custom functions enable you to

YouTube

Perform Basic Covariance Analysis in Excel

Check out my Blog: http://exceltraining101.blogspot.com Covariance is one of those statistical functions that help you determine the relationship between two

YouTube

Managing changing column names in Power Query #10: (M)agic (M)ondays

In today's video, I will show how to manage column headers that changes names so your power bi file does not break when you refresh it. This tip is from Lars S

YouTube

Combine CSV Files with Power Query

Check out my Blog: http://exceltraining101.blogspot.com The video shows how to combine multiple comma separated files (CSV) together into one file. This proc

YouTube

Create a Reference Table or List with Power Query

Check out my Blog: http://exceltraining101.blogspot.com Say you have a table of data and you need to get a set of unique values from a column of the records.

YouTube

Power Query Running Count Based on Row Condition – Excel Magic Trick 1588

COUNTIFS($A$1:A1,A1) Formula in Power Query? - Excel Magic Trick 1588 Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1588.xlsx Le

YouTube

Advanced PivotTables: Combining Data from Multiple Sheets

See companion tutorial and sample files on Tuts+: https://computers.tutsplus.com/tutorials/advanced-pivottables-combining-data-from-multiple-sheets--cms-21190.

YouTube

How to Write an IF Function in Power Query Including Nested IFs

The IF function is one of the most useful in Excel. In this video we look at how to write an IF function in Power Query. The video includes three examples. Fir

YouTube

How to use Excel Index Match (the right way)

Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Quickly learn all you need to know about INDEX & MATCH to get a quick s

YouTube

Compare Shipped and Received Items with Power Query and Power Pivot

Check out my Blog: http://exceltraining101.blogspot.com This video shows how to use Power Query and Power Pivot to compare units ordered, shipped and received

YouTube

Create an Interactive Form with Power Query

Check out my Blog: http://exceltraining101.blogspot.com Do you want to add some interactivity to your Excel? You send the Excel file to someone and they can

YouTube

Perform a Lookup with Multiple Criteria

Check out my Blog: http://exceltraining101.blogspot.com If you've perform lookup before it's usually looking up something with one criteria (i.e., finding the

YouTube

Merge Tables in Power Query

Check out my Blog: http://exceltraining101.blogspot.com This video covers the Merge capability in Power Query. The are six type of merges one can do in Power

YouTube