Skip to content
Data Analytics Logo
  • Home
  • About Us
  • Course Portfolio
    • Microsoft Excel for Professionals
    • Microsoft Excel Advanced Master Class
    • Power BI
  • Blog
  • Photo Gallery
  • Register
  • Menu

Tag Archives: AMPERSAND

Perform VLOOKUP with Multiple Lookup Values in Three Ways

Posted on February 9, 2020February 10, 2020 by Abiola David | No Comments

Welcome to Excel Jet Consult. In this tutorial, we will learn how to perform VLOOKUP with multiple lookup values in three ways. Let’s get started In the caption below, we have a sample data to work with Note, we have list data validation in cells F2:H2. So, we want to return the Sales Total result for Abiola David with States […]

Continue reading→

Blog Posts

  • Convert Numbers to Proper Time Format in Power Query
  • Transform Report to Dataset using Power Query
  • Combining TEXTBEFORE & TEXTAFTER Function with SUMIFS in Excel
  • APPEND Data From Multiple Sheets & Get Total Row using VSTACK & HSTACK
  • Brand New TEXTSPLIT, TEXTAFTER & TEXTBEFORE Functions
  • How SWITCH Function will make you the “Go-to Person”
  • Dynamic Array FILTER by Month & Quarter
  • ADVANCED Filter Super Trick to Reorder Entire Columns without Criteria
  • 3 Hidden Tips & Tricks You Probably Don’t Know About ADVANCED Filter
  • Author LAMBDA Custom Function using New Advanced Formula Editor
  • Calculate Sales Commission for Weekdays & Weekends using Power Query M Code
  • New Automatic Searchable Dropdown in Excel [No More Formula-Based Solution]
  • Conditional Formatting using XLOOKUP and FILTERS Functions in Excel for the Web
  • Create Workbooks from Worksheets using VBA
  • Power Query Classic COUNTIFS | SUMIFS | AVERAGEIFS | MAXIFS | MINIFS Calculations [Simply Amazing]

Copyright 2019 © Excel Jet Consult. All Rights Reserved

A SiteOrigin Theme