#1030106
The function … returns a value or reference of the cell at the intersection of a particular row and column in a given range.
Варианты ответа:
  • VLOOKUP(lookup_value, table_array, col_index_num)
  • INDEX(array, row_num, col_num)
  • MATCH(lookup_value, lookup_array, match_type)
  • HLOOKUP(lookup_value, table_array, row_index_num)
Тематика: Математические и инструментальные методы поддержки принятия решений Системный анализ и принятие решений Учет и анализ
Курсы в категории: Математика и статистика
📚 Похожие вопросы по этой дисциплине
Which of the following Lookup functions returns the relative position of an item in an array that equals a specified In a MATCH function, if the match_type = For which of the following MATCH functions must the values in the lookup_array be ordered To select a chart type in Excel from the Charts group, which tab has Roger wants to compare values across categories using vertical rectangles. Which of the followin