Premium Only Content

Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples Duration: 10:36 minutes
Find out how to do a VLOOKUP in Excel and for what situations you can use Excel's Vlookup and Hlookup formulas for.
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
Timestamps
00:00 Basics of Excel VLOOKUP and HLOOKUP
00:57 How to use Excel VLOOKUP
07:14 How to use Excel HLOOKUP
09:59 Limitation of Excel VLOOKUP and HLOOKUP
The Excel VLOOKUP formula can search for a specific category or value in an Excel data table and return the “opposing” value from adjacent columns. HLOOKUP function works exactly in the same way except that it looks horizontally rather than vertically.
“V” in VLOOKUP refers to vertical and “H” in HLOOKUP refers to horizontal. If the data in your table has column headers, use the VLOOKUP function. If the data table has row headers and you need to search horizontally across the rows for a “match” then use HLOOKUP formula.
Vlookup formulas do not need to have sorted lists. If your Excel table is unsorted make sure you look for an exact match by selecting "false" in the last argument of Vlookup.
One major limitation of VLOOKUP is that it cannot look to the left. The values to lookup must always be on the left-most column of the range and the values to return must be on the right hand side.
For two-way lookups - If you need to look up values across rows and also columns or multiple rows and columns the best function to use is the Index and Match function. Watch this video to learn more:
• How to use Excel Index Match (the rig...
-
LIVE
Dr Disrespect
7 hours ago🔴LIVE - DR DISRESPECT - IMPOSSIBLE 5 CHICKEN DINNER CHALLENGE - FEAT. VISS
1,248 watching -
LIVE
The Jimmy Dore Show
39 minutes agoTrump Administration Sends Accused Pedo BACK TO ISRAEL! Ukrainians Now OVERWHELMINGLY Oppose War!
4,454 watching -
DVR
TheCrucible
2 hours agoThe Extravaganza! Ep. 24 (8/20/25)
14.3K1 -
1:18:42
Kim Iversen
2 hours agoUFO Base Area 51 Catches Fire… Is It a Massive Cover-Up?!
5.04K29 -
1:51:18
Redacted News
2 hours ago"There will be consequences!!!" Trump issues big threat to Putin ahead of peace summit | Redacted
66.6K43 -
53:14
Candace Show Podcast
2 hours agoThe MOST MORAL Blackmail In The World | Candace EP 231
18.8K80 -
1:11:28
vivafrei
4 hours agoMatt Taibbi Getting "Westfalled"? Kathy Hochul Fighting for Illegals! Mamdani Minority Report & MORE
70K28 -
2:03:39
Pop Culture Crisis
4 hours agoWTF Happened to Miley Cyrus? HARRY POTTER Set Images, Sydney Sweeney Hater EXPOSED | Ep. 901
18.4K18 -
10:17
MattMorseTV
4 hours ago $5.37 earnedTrump's DOJ just DROPPED a NUKE.
23.8K31 -
11:07
Politibrawl
12 days agoRepublican rising star DESTROYS theatrical Democrat in front of the entire world
66.7K30