Excel's VLOOKUP Function

Referred URL

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

Using Excel's 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