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

# Perform a Two Column Lookup with Power Query

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

## Power Query: Index and Modulo Functions

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

## 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

## 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

## 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

## 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

## 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

## 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

## 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

## 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

## 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

## 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.

## 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.

## 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

## 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

## 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

## 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