أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
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, …)
You cannot use more than one table for the simple reason that the table must be sorted in the ascending order
SyntaxVLOOKUP(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.