Microsoft Excel - about vlookup - Asked By ayaz jafri on 25-Jan-12 12:25 AM

I want to use vlookup formula in 20 worksheet. Help me
Jitendra Faye replied to ayaz jafri on 25-Jan-12 12:36 AM
You can create like this-

Syntax:    (As always look in HELP for more information)

   VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
    range_lookup can be TRUE or FALSE, if omitted the default is TRUE
smr replied to ayaz jafri on 25-Jan-12 12:43 AM
hi

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


Vlookup’s format looks like the following:

=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.

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.
follow links for more examples
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/