Premium Only Content

Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples
Mar 5, 2017 Excel Lookup Formulas
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
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: https://youtu.be/F264FpBDX28
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
1:33:39
Redacted News
2 hours agoBREAKING! Europe goes NUCLEAR against Trump over pushing for PEACE in Ukraine | Redacted
53.8K85 -
1:01:13
Candace Show Podcast
3 hours agoBlake Lively's BOMBSHELL Legal Filing | Candace Ep 149
64.3K49 -
1:41:00
Darkhorse Podcast
4 hours agoIf Only We’d Known: The 265th Evolutionary Lens with Bret Weinstein and Heather Heying
44.5K23 -
1:11:22
Vigilant News Network
6 hours agoElon Musk Shuts Down RFK Jr. Critics With One Powerful Statement | The Daily Dose
37.6K6 -
LIVE
Dad Dojo Podcast
18 hours agoEP20: The Super Bowl and Solving The Economy
59 watching -
4:49
Tactical Advisor
3 days agoBest Small Handgun Optics | CH PWS Shot Show 2025
151 -
1:01:21
In The Litter Box w/ Jewels & Catturd
22 hours agoI've Got Your Proof - Right Here! | In the Litter Box w/ Jewels & Catturd – Ep. 745 – 2/19/2025
61.3K23 -
2:14:30
FreshandFit
6 hours agoDavid Icke On COVID Lies, Censorship, Secret Societies, Infiltration of MAGA, AI Control, Alternative Media Subversion And MORE!
85.1K35 -
1:41:41
The Quartering
8 hours agoTrump's New IVF Order, GameStop CEO Denounces Wokeness Amid Sale, and Elon Musk's DOGE Role Revealed
92.3K54 -
LIVE
Dr Disrespect
7 hours ago🔴LIVE - DR DISRESPECT - TARKOV - ZERO TO HERO PISTOL ONLY
2,393 watching