VLOOKUP( lookup_value; data_table; column_index; [mode] )

lookup_value : The value to look for in a range/array. E.g. "Apples", 2508

data_table : The table containing the data to test. E.g. A1:E45

column_index : The column that you want to get the corresponding value from (starting with 1 for the left-most column in the data table). E.g. 3

mode : Specifies how the data_table must be,

-1 - The first column must be sorted in descending order. The exact match or the next greatest value is considered.

0 - The first column can be unsorted. The exact match or regex match is considered.

1 and >2 - The first column must be sorted in ascending order. The exact match or the next smallest value is considered.

Remarks

• VLOOKUP can be used to bring corresponding data from other worksheets.

• Use named ranges for  data_table . This helps refer a single source data table to create multiple tables for calculation and analysis.

• If you don't remember the complete text you have to search for, use  .*, .?  and  /  instead.

            .* - Can be used to replace any number of characters. E.g.  Zyl.*  finds  Zylker
            .? - Can be used to replace a single character. E.g.  Mar.?us  finds  Marcus  and  Markus .

            / - Can be used to include *, ? and / in the search term. E.g.  Zylker/*  finds  Zylker*  and Mar.?us/?   finds  Marcus ? and  Markus ?

• VLOOKUP is case-insensitive, e.g. "APPLES" and "Apples" are treated similarly.