I want to use vlookup formula in 20 worksheet. Help me

hi

**VLOOKUP retrieves information from a database/list based on a supplied instance of the unique identifier.**

**=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)**

**Explanation:**

**Lookup _value: **

This argument is the value that is searched for in the first column of the table array. The lookup _value can be a text string, a logical value (TRUE or FALSE only), a number, or a cell reference to a value.

http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

http://www.howtogeek.com/howto/13780/using-vlookup-in-excel/

http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a-simple-tutorial-part-i/

**Vlookup’s format looks like the following:**

This argument is the value that is searched for in the first column of the table array. The lookup _value can be a text string, a logical value (TRUE or FALSE only), a number, or a cell reference to a value.

**table_array: **

This is the range of data that the function searches to find your information. The table_array must contain at least two columns of data. The first column
contains the lookup_values. These values can be text, numbers, or
logical values. This argument is a named range or a reference to a range of cells.

**col_index_num:**

For this argument, enter the column number of the table_array from which you want data returned from. For example:

- if the col_index_num is 1, it returns a value from the first column in table_array;
- if the col_index_num is 2, it returns a value from the second column in table_array.

**range_lookup:**

A logical value (TRUE or FALSE only) that indicates whether you
want VLOOKUP to find an exact or an approximate match to the
lookup_value.

- If TRUE or if this argument is omitted, VLOOKUP will use an
approximate match if it cannot find an exact match to the lookup_value.
If an exact match is not found, VLOOKUP uses the next largest
lookup_value.

- If FALSE, VLOOKUP will only use an exact match to the lookup_value. If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, an #N/A error is returned.

http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

http://www.howtogeek.com/howto/13780/using-vlookup-in-excel/

http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a-simple-tutorial-part-i/