Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)
Date Posted: 2015/02/26
Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL

 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
by 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