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

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...
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...
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...
Tutorial Details
Excel Function: VLOOKUP()
Downloadable Files: Excel File
Excel VBA Course
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