30 Second VLOOKUP() in Excel

Add to Favorites
Author: | Edits: don

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)


Excel Function: VLOOKUP()
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course

(35% Sale Ends Jan. 26)

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.)

View Course (35% Discount)

Similar Content on TeachExcel
Run a Macro at Set Intervals in Excel
Tutorial: Run a macro every 30 seconds, 1 minute, 10 minutes, 1 hour, etc.; this method allows you t...
Remove Vlookup #N/A Error in Excel
Tutorial: How to remove the #N/A error from Vlookup and replace it with a friendly message or a bl...
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
VLOOKUP() Function in Excel
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when yo...
Vlookup on Dates and Times in Excel
Tutorial: Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of l...
Calculate the Total Time Worked Minus Lunch Breaks in Excel
Tutorial: Ill show you how to use Excel to calculate the total time worked in a day minus lunch tim...
Tutorial Details
Excel Function: VLOOKUP()
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

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.)

View Course (35% Discount)