Premium Only Content
![ALL Excel LOOKUPs explained](https://1a-1791.com/video/s8/1/a/5/q/3/a5q3e.qR4e-small-ALL-Excel-LOOKUPs-explained.jpg)
ALL Excel LOOKUPs explained
Download our guide on all Excel lookups:
https://excel.tv/all-excel-lookups-explained/
Go to excel.tv for more!
What did you think of this video? Leave your comments below.
Make sure to SUBSCRIBE NOW to receive updates regularly.
Over the years, I’ve noticed a lot of folks having trouble understanding Excel LOOKUP functions. By lookup functions, I mean LOOKUP, HLOOKUP, VLOOKUP, MATCH, and XLOOKUP.
So, in this video, I am trying to bring together what all of these lookup functions have in common. In this way, my hope is that you get a sense of the theory that comprise these functions. If you can understand the theory, then the old functions take on new meaning. Better yet, new functions like XLOOKUP make a lot more sense – and you’ll learn them in an instant.
You’ll see a lot of this in the video, but for now, let me see what I can summarize in this writing.
All Excel lookup functions follow this same framework. Let’s take a look at the VLOOKUP function:
VLOOKUP( what_we’re_searching_for, where_we’re_going_to_look, column_number_to_pull, the_match_type)
Now, let’s replace the following parameters from our VLOOKUP with symbols
🔎 = what_we’re_searching_for
🗄️ = where_we’re_going_to_look
… = column_number_to_pull
❓ = the_match_type
…and let’s put them back into our lookup:
VLOOKUP( 🔎, 🗄️, …, ❓)
Let’s consider “…” to refers to any optional parameter that is part of a lookup. And now let’s extend this idea…
The MATCH function, which returns the record location where a value is matched within a row or column follows a similar dynamic:
MATCH( what_we’re_searching_for, where_we’re_going_to_look, the_match_type)
… and we can assign the symbols as follows….
🔎 = what_we’re_searching_for
🗄️ = where_we’re_going_to_look
❓ = the_match_type
MATCH( 🔎, 🗄️, ❓)
In fact, we can summarize ALL excel lookup functions with the following axioms:
1. The first parameter 🔎 is always what you’re looking for
2. The second parameter 🗄️ is always where you’re going to look
3. The third parameter … represents additional options specific to that lookup type (MATCH has no options; VLOOKUP and HLOOKUP have options; XLOOKUP does as well, we’ll get to that in a second)
4. The final parameters(s) ❓ is/are always the match type(s)
Which means all Excel lookups following this generalized form:
LOOKUP( 🔎, 🗄️, …, ❓
-
2:33:51
John Crump Live
10 hours ago $3.04 earnedSaturday Night Main Event!
33K2 -
13:57
TimcastIRL
16 hours agoTrump NUKES IRS After DOGE Investigation, OVER 9000 Employees To Be FIRED
69.6K149 -
13:35
Russell Brand
9 hours agoPFIZER JUST MADE THEIR NEXT MOVE AND EXPERTS ARE TERRIFIED
89.8K153 -
1:15:57
Victor Davis Hanson Show
19 hours agoOver Here, Over There: the Russo-Japanese War and Trumpian Peace Policy
39.1K17 -
23:55
MYLUNCHBREAK CHANNEL PAGE
1 day agoThe Nephilim Are Here
73.5K59 -
1:00:58
Break The Cycle w/ Joshua Smith
6 hours ago $0.86 earnedBreak The Cycle Ep. 247: Funny Guys w/ Robbie "The Fire" Bernstein
16.8K1 -
41:26
TheTapeLibrary
21 hours ago $7.98 earnedThe Disturbing Horrors of the Trans-Allegheny Lunatic Asylum
49.5K3 -
10:07
Tundra Tactical
7 hours ago $5.54 earnedTRUMP'S HUGE GUN RIGHTS MOVE!
32.1K7 -
1:53:23
Mally_Mouse
7 hours agoSaturday Shenanigans!! - Crowd Control - Content Warning
23.6K1 -
17:24
Exploring With Nug
12 hours ago $3.34 earnedScuba Diving on Underwater Cars Searching For Missing Man!
38.5K1