ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)
تاريخ النشر: 2015/02/26
Ahmed Maher allam
من قبل 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
من قبل 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. 

المزيد من الأسئلة المماثلة