Excel's VLOOKUP Function

by - 8:29 PM


Referred URL
http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm

Using Excel's VLOOKUP Function
Using the Excel VLOOKUP Function


Vlookup’s format looks like the following:
vlookup(Lookup value, Table where values reside, column Number, False)

Parameter Definition 
Lookup value - Value you want to check (Ex: You need to check for Bolt)
Table where values reside - Select the comparing source table  
Column # where values are located - Enter the column number for value. 
                                                       (Ex: Part - Column 1, Price - Column 2 )
True/ False - True means exactly look for the same value 

You May Also Like

0 comments

FOLLOW ME @INSTAGRAM

Created with by BeautyTemplates | Distributed by blogger templates