Excel VLOOKUP Function

Use:
Uses a specified key to return a value from a column of a vertically organized table
Syntax:
VLOOKUP( key , table , column )
Examples:
Cell C13 formula:   VLOOKUP( B13 , B3:G8 , 3 ) determines the cost to send a 13.7 pound package by courier
Cell D13 formula:   VLOOKUP( B13 , B3:G8 , 5 ) determines the lowest cost to send a 13.7 pound package
Cell E13 formula:   VLOOKUP( B13 , B3:G8 , 6 ) determines the lowest cost mode to send a 13.7 pound package
 

Note:
The leftmost column of the vertical table must be the key comparison column. It must be sorted in ascending order.
 

It is often handy to specify the table by an absolute address ($B$3:$G$8) instead of a simple relative address (B3:G8). This greatly simplifies copying vlookup formulas to other cells in your spreadsheet.

Related Function:
HLOOKUP and MATCH