30 Second VLOOKUP() in Excel
Learn to use the VLOOKUP function for Excel in 30 seconds or less!
This tutorial includes seaching through a list of values for an exact match using Vlookup as well as searching through a sorted list of numbers to return either an exact match or the next lowest value.
Vlookup to Search an Exact Match
=VLOOKUP("Red",B5:D8,3,FALSE)(Download the file for this tutorial to get the lookup data as well.)
Vlookup to Search for an Approximate Match
=VLOOKUP(85,B15:C18,2,TRUE)(Download the file for this tutorial to get the lookup data as well.)
Additional Resources
Vlookup Excel (microsoft's page)
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: Run a macro every 30 seconds, 1 minute, 10 minutes, 1 hour, etc.; this method allows you t...
Tutorial: How to remove the #N/A error from Vlookup and replace it with a friendly message or a bl...
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when yo...
Tutorial: Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of l...
Tutorial: Ill show you how to use Excel to calculate the total time worked in a day minus lunch tim...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)