Friday, November 23, 2012

Excel's VLOOKUP Function


Referred URL

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 

No comments: