Vlookup Excel Formula




Excel Formulas > Logical & Reference Functions > VLOOKUP

« Sumif | Vlookup | Day »

What is the use of Vlookup formula?

Searches a list for a value you are looking for and returns a corresponding value


Syntax of Vlookup formula:
vlookup(this value, in this list, and get me value in this column, [is-my-list-sorted?])

Examples of Excel Vlookup formula:
vlookup("John", list, 2, false) = finds where Jon is in the list and returns the value in the 2nd column


Buy Excel Formula E-book | Learn more about Excel Vlookup Formula

More Logical & Reference Functions : And | Countblank | Countif | If | Large | Max | Min | Not | Or | Small | Sumif | Vlookup

Mathematical Functions | Text Functions | Logical & Reference Functions
Date & Time Functions | Financial Functions | Information Functions

Microsoft Excel Formula Training - Ebook