• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

vlookup

vlookup in power query using list functions

VLOOKUP in Power Query Using List Functions

July 29, 2021 by Philip Treacy

If you've done lookups in Power Query to pull values from one table into another, you may have used a query merge to do this. Mynda has written previously on how to do an Exact Match in Power Query and an Approximate Match in Power Query Here I'll be showing you how to use List …

Read moreVLOOKUP in Power Query Using List Functions
VLOOKUP Multiple Values in Multiple Columns

VLOOKUP Multiple Values in Multiple Columns

May 16, 2013 by Mynda Treacy

A few weeks ago David T asked me to help him understand a VLOOKUP formula in a workbook he’d inherited from a colleague who had left his company. It was a VLOOKUP formula like nothing I’d ever seen before so I thought I’d share it with you. Drum roll….. =VLOOKUP(E2&F2,IF({1,0},First_Name&Last_Name,Grade),2,FALSE) David’s question was ‘what’s the …

Read moreVLOOKUP Multiple Values in Multiple Columns
Excel VLOOKUP Multiple Sheets

Excel VLOOKUP Multiple Sheets

November 21, 2012 by Mynda Treacy

This week I had a question from Diedre asking if she can use VLOOKUP to check multiple sheets…. 17 different sheets in fact. The idea being that if VLOOKUP doesn’t find a match on the first sheet, it will check the next sheet and so on. The good news is we can, the bad news …

Read moreExcel VLOOKUP Multiple Sheets
Excel Factor 17 Lookup and Return Multiple Matches

Excel Factor 17 Lookup and Return Multiple Matches

October 3, 2012 by Mynda Treacy

This Excel Factor tip was sent in by Bob Cooke of Lincolnshire, England. Words by Mynda Treacy Last week Bob emailed me with an example of how he uses the INDEX, SMALL, IF and ROW functions to lookup a list and return multiple matches like this:   It’s good timing as I actually had this …

Read moreExcel Factor 17 Lookup and Return Multiple Matches
Excel Factor 16 Dynamic Lookup

Excel Factor 16 Dynamic Lookup

September 22, 2012 by Mynda Treacy

This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Words by Bryon Smedley. Enter your email address below to download the sample workbook. Get Workbook By submitting your email address you agree that we can email you our Excel newsletter. Please enter a valid email address. Download the Excel Workbook and …

Read moreExcel Factor 16 Dynamic Lookup
VLOOKUP Multiple Criteria

VLOOKUP Multiple Criteria

February 15, 2012 by Mynda Treacy

I had an email from Bobcat today asking how to lookup data that is spread across multiple columns.   Table 1 has data with the name in just one column: And Table 2 has the name across 3 columns (D, E and F): We want to find the Employee number from Table 1 and put …

Read moreVLOOKUP Multiple Criteria
Excel VLOOKUP Multiple Values

Excel VLOOKUP Multiple Values

December 7, 2011 by Mynda Treacy

For some of us we use the VLOOKUP function all the time and for the most part is does exactly what we want, but what if you want to lookup multiple columns? Taking the example below; in cell B3 I have a data validation list that allows me to choose the player I want to …

Read moreExcel VLOOKUP Multiple Values
Excel Wildcards in your SUMIF, COUNTIF and VLOOKUP

Excel Wildcards in your SUMIF, COUNTIF and VLOOKUP

August 31, 2011 by Mynda Treacy

Wildcards *?~....what am I talking about? And no, it's not an expletive. Let’s start with an example. COUNTIF using Wildcards What say you wanted to count the number of cells containing the word ‘apple’ in this table. You could simply use a wildcard (an asterisk, *, is a wildcard in Excel) in your COUNTIF formula …

Read moreExcel Wildcards in your SUMIF, COUNTIF and VLOOKUP
Excel VLOOKUP with Dynamic Column Reference

Excel VLOOKUP with Dynamic Column Reference

June 22, 2011 by Mynda Treacy

If you ever work with large tables of data and you want to insert a VLOOKUP formula that dynamically updates to the next column as you copy it across, then the VLOOKUP with the COLUMNS function is what you need. That is; the col_index_num part of the VLOOKUP function dynamically updates as you copy it …

Read moreExcel VLOOKUP with Dynamic Column Reference
Excel VLOOKUP to the Left Using CHOOSE

Excel VLOOKUP to the Left Using CHOOSE

February 1, 2011 by Mynda Treacy

A little while ago I showed you how to do a lookup to the left using the INDEX and MATCH functions. In this Excel tutorial I’m going to show you how you can do a lookup to the left with a VLOOKUP formula together with the CHOOSE function as an alternative. Let’s look at our …

Read moreExcel VLOOKUP to the Left Using CHOOSE
  • Go to page 1
  • Go to page 2
  • Next

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.