Vlookup

• Vlookup is a function in Microsoft Excel that allow you to use a section of your spreadsheet as a lookup table.
• The function returns another value in the same row, defined by the column index number.

Syntax:

• VLOOKUP( lookup_value, table_array, col_index_num, [range_lookup] ).
• The function arguments are:

lookup_value	The value that you want to search for.
table_array	The array of data that is to be searched for the lookup_value. The Vlookup function searches in the left-most column of this array.
col_index_num	An integer, specifying the column number of the supplied table_array, that you want to return a value from.
[range_lookup]	An optional logical argument, which describes what the function should return in the event that it does not find an exact match to the lookup_value. The [range_lookup] can be set to TRUE or FALSE, meaning: TRUE - Find the closest match below the lookup_value if the exact value is not found. FALSE - Find an exact match to the lookup_value - if an exact is not found, the function returns an error. If the [range_lookup] value is omitted, it uses the default value of TRUE.

Example

• The following picture shows how you'd set up your VLOOKUP to return the price of Oil pan, which is 7000.

• Just type the formula see below image.

• Press Enter it will show the result see below image.

Vlook up using two sheets

• Same Syntax extra adding sheet name and get the result.