General Functions in Excel

From NovaOrdis Knowledge Base
Revision as of 04:15, 21 December 2023 by Ovidiu (talk | contribs) (Created page with "=Internal= * Excel =<tt>INDEX</tt>= The <code>INDEX</code> function returns a value or a reference to a value from a table or range. <font size...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Internal

INDEX

The INDEX function returns a value or a reference to a value from a table or range.

INDEX(array, row_num, [column_num])

where:

  • array is a range of cells or an array constant.
  • row_num selects the row in array from which to reenter the value.