How to use vlookup in excel

VLOOKUP is one of Excel most useful functions, and it’s also one of the least understood.  In this article, we will discuss about how to use VLOOKUP in excel. So what is VLOOKUP?  Well, of course it’s an Excel function.  This article will assume that the reader already has a passing understanding of Excel functions, and can use basic functions such as SUM, AVERAGE, and TODAY. In its most common usage, VLOOKUP is a database function, meaning that it works with database tables – or more simply, lists of things in an Excel worksheet.  What sort of things?   Well, any sort of thing.  You may have a worksheet that contains a list of employees, or products, or customers, or CDs in your CD collection, or stars in the night sky.  It doesn’t really matter. To use VLOOKUP you can follow this steps below :

1. Go to Formulas > Insert Function
2. Type VLOOKUP and click GO and click OK
   
   
3. In window :
   Lookup value choose Field that you want to be looked.
   Table Array choose Reference table from where the value will be looked
   Col Index Num choose field index of table column from where the value will be generated
   Range Lookup True it will use exact match, False for closest match
   
   
4. Press OK