Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Which function if added let me use two table arrays or more in Vlookup function instead of one table array?

user-image
Question ajoutée par Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)
Date de publication: 2015/02/26
Ahmed Maher allam
par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

 You can use the choose function to choose which table to use by refereeing to each table by number or character :

 

=CHOOSE(index_num, value1,value2, …)

Waldek Hiero
par Waldek Hiero , Collaboration Engineering and Development , Brown Brothers Harriman

You cannot use more than one table for the simple reason that the table must be sorted in the ascending order

Syntax

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

The VLOOKUP function syntax has the following arguments:

  • lookup_value    Required. The value to search in the first column of the table or range. The lookup_value argument can be a value or a reference. If the value you supply for the lookup_value argument is smaller than the smallest value in the first column of the table_array argument, VLOOKUP returns the #N/A error value.

  • table_array    Required. The range of cells that contains the data. You can use a reference to a range (for example, A2:D8), or a range name. The values in the first column of table_array are the values searched by lookup_value. These values can be text, numbers, or logical values. Uppercase and lowercase text are equivalent. 

More Questions Like This