# 30 Second VLOOKUP() in Excel

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

Vlookup Excel (microsoft's page)

Excel Function: VLOOKUP()

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

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