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: TEXTJOIN

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

  • #MsSQLServer: Calculate Total Revenue by Brand
  • Track Forbes MPP Birthday Status using IFS Function in #Excel
  • MID and SEARCH Text Functions Inside SUMIFS plus List Data Validation
  • Retrieve Single and Multiple Non contiguous columns in MS SQL Server
  • Connect and Import Data from Excel to SQL Server
  • Combo Chart in PowerPoint using Excel Data
  • Recursive LAMBDA with Structured Reference
  • Total Sales in Excel & Tableau
  • Array Constants with VLOOKUP in Excel and Google Sheets Compared
  • Calculator in Excel VBA Coding Part 2
  • Calculator in Excel VBA Coding Part 2
  • How to Create Animated GIF in PowerPoint (Covid-19 Slides)
  • Create Animated GIF in PowerPoint
  • Excel Hash Challenge 2021
  • Calculator in Excel VBA (User Interface Design) Part One

Copyright 2019 © Excel Jet Consult. All Rights Reserved

A SiteOrigin Theme