Name: VLookup Hack!!!
Uploaded: 2022-09-08T18:00:29.000Z
Duration: 36 s
Description: See how to return multiple columns of data with 1 vlookup formula. This hack makes VLookup function a bit more like XLookup.

See how to return multiple columns of data with 1 vlookup formula. This hack makes VLookup function a bit more like XLookup.

Microsoft Excel

Hi my name is Derrick and I have spent many years mastering Microsoft Excel to include how to write VBA macros from scratch.  I am the "Go to person" for all things Excel related where ever I go.  I have worked with and built tools and templates for several companies both large and small. 
  
Excel is very powerful and can make you very marketable in the job space.  All of my students will receive the material we covered after each session.  This material includes talking points and practice exercises.  There is a lot to take in and I feel by sending this material out to my students it gives them a document to go back to as a reference.  This will also allow you to review the material and generate questions that I will be more than happy to answer for you at any time.

Every session will build upon the previous session and progress in complexity as we go, so long as you are comfortable with the previous lessons material.    

When you are ready to become an Excel and VBA superuser I will be here to go on that journey with you.  We will definitely have fun on our journey as well.  Hope to hear from you soon and please ask me any questions you may have.

VLookup Hack!!!

2bf2255c-05e8:37755;isclassifiedstrendingsuggestionsenableddt:42136;316f64c0-2415:46048;b2454379-d6cf:44572;335d7519-3303:46159;31885555-099a:47313;1a645375-144d:47316;ei83g319:53872;47h3f766:58362;fg008402:58376;i6jj6667:86739;istutorredesignv2_1:73124;a5gbd220:61179;blogpwt:71359;5db3b892:67466;2a2j8400:70238;b534g232:70741;j91hb444:69773;18h21436:69961;85h98405:81245;0eie7335:76839;cia78296:75037;9b4gd804:78753;deisn977:110326;1d789912:110325;slcardst:87990;searchranking_newpqs:91321;b1ff5649:88417;d9c7i206:87231;ajgj0920:88926;a1d06430:92612;15gbg809:92228;3cf2h499:95552;90ahj157:94513;2a718373:100011;gg41j822:94817;3i5dg498:97157;05c5i927:97770;06ieg414:100430;9ab7j510:99496;86afb588:101093;bfb37872:105751;7f8gg909:114000;e36bg556:114647;

Visual Basic

Beginner

Intermediate

Advanced

Kappa Alpha Psi ®, now comprised of functioning Undergraduate and Alumni Chapters on major campuses and in cities throughout the country, is the crystallization of a dream. It is the beautiful realization of a vision shared commonly by the late Revered Founders that enabled them to sow the seed of a fraternal tree whose fruit is available to, and now enjoyed by college men everywhere, regardless of their color, religion or national origin.

It is a fact of which Kappa Alpha Psi ® is proud that the Constitution has never contained any clause which either excluded or suggested the exclusion of a man from membership merely because of his color, creed, or national origin.

Kappa Alpha Psi ® is the 2nd oldest existing collegiate historically Black Greek Letter Fraternity and the 1st intercollegiate Fraternity incorporated as a national body. It remains the only Greek letter organization with its Alpha Chapter on Indiana University’s campus. The Fraternity has over 125,000 members with 700 undergraduate and alumni chapters in nearly every state of the United States, and international chapters in Nigeria, South Africa, the West Indies, the United Kingdom, Germany, Korea and Japan.

Completed the Udemy course to receive a certification as an advanced Excel user.

Developed a tool that allowed the company to move away from a process of gather patent id numbers that was taking them 8 hours to complete.  Once my tool was launched the same results were acquired in 6 minutes.  This saved them time, money, energy and allowed them to run the process more often.

Freelance Excel Developer

I write code for various customers to automate processes where Excel is utilized.

Head VBA Programmer

English

I believe that learning Excel can open doors to new career fields and will make any applicant standout from the pack.  For those reasons my strong passion is to give my extensive skills and knowledge in this program to everyone.  I also believe relationships are important and not only will you learn Excel and become great at it, but we will have fun doing so.

He is very clear with his teaching style.

Derrick is a great Instructor. He goes through the steps and explains and defines everything. He's wonderful!

Quite patient.  Very knowledgeable.  Has a study plan ready for you, but if you have questions about a different part of Excel, he's happy to switch over for you.  Would definitely recommend.

In this video you will learn about the top 5 Excel functions that will help make working in Excel much, much easier. 

Top 5 EXCEL Functions ***YOU WANT TO KNOW***

Learn about the 3 different cell references in Excel. See how formulas will react when they are dragged using the fill handle. We will discuss the different references and then do some examples where we use each reference type.

Cell References***Absolute; Dynamic and Mixed***

In this video we will learn how to aggregate our data when we have multiple criteria that must be met. We will cover how to use Countifs, Averageifs and Sumifs with multiple examples. Please enjoy and thank you!

Lets Learn Countifs, Sumifs and Averageifs***Multiple Criteria***

Learn how and when to use three very important functions in Excel. We will take a look at how to use the countif, sumif and averageif functions. We take our time and discuss each function in detail including the syntax, then we use the functions in an example together. 

***3 POWERFUL Excel Functions: Countif, Sumif and Averageif***

If you need to know about Pivot Tables and how to create them, then this is a must watch video! We will cover the basics behind how to create pivot tables along with how to change elements of pivots as well as how to apply formatting to Pivot Tables. This will be a one stop shop for understanding Pivot Tables 101!

Pivot Tables 101

Learn the basics behind what makes the Xlookup function work and what makes it so very helpful. In this video you will learn about the syntax for the Xlookup function and get to watch it in action as we cover 5 examples. 

XLookup Explained!!!

Tables in Excel are powerful! Learn the difference between using official Excel tables and regular formatted spreadsheets. You will learn how to create tables in Excel and what the advantages are to using tables. From auto-sizing, automatic named ranges, auto-formatting, auto-data population plus more. 

Excel Tables Explained

See how to navigate through your data quicker. See how to quickly determine your last row and last column and more. This is part 1 of a multi -part series.

Extremely Useful Excel Shortcuts Pt. 1

In this video you will learn about how to use Nested IF functions in Excel. This can be very powerful and convenient when you need to output something based on multiple criteria being true or false. 

Nested If Statements

Learn to use functions Index and Match together to form lookup function that is far more powerful than VLookup. This will be a deep dive into how this complex function truly operates.

Derrick M.

VLookup Hack!!!

Derrick's Microsoft Excel videos

Top 5 EXCEL Functions YOU WANT TO KNOW

Cell ReferencesAbsolute; Dynamic and Mixed

Lets Learn Countifs, Sumifs and AverageifsMultiple Criteria

3 POWERFUL Excel Functions: Countif, Sumif and Averageif

Pivot Tables 101

XLookup Explained!!!

Excel Tables Explained

Extremely Useful Excel Shortcuts Pt. 1

VLookup Hack!!!

Nested If Statements

Index MatchBETTER THAN VLOOKUP!!!

Learn Index Match

Teacher Reviews (5)

Book online lesson

How to Find Duplicates in Microsoft Excel

How to Automatically Add Borders in Microsoft Excel

How to Transpose Data in Microsoft Excel

How to SUM in Microsoft Excel

Excel color changing status

Excel dashboard with donut chart and progress bars

Excel dashboard tutorial with navigation bar

Excel color scale rank chart tutorial

How to Split Text to Columns in Microsoft Excel

How to Calculate Mean, Standard Deviation and Standard Error in Microsoft Excel

Related Subjects