XOR ADDRESS

Lookup

  • ADDRESS — cell address as text
  • AREAS — number of areas in reference
  • ARRAY — vertical array of the arguments
  • CHOOSE — the (index+1)th argument
  • COLUMN — vector of column numbers
  • COLUMNNUMBER — column number for the given column called name
  • COLUMNS — number of columns in reference
  • HLOOKUP — search the first row of range for value
  • HYPERLINK — second or first arguments
  • INDEX — reference to a cell in the given array
  • INDIRECT — contents of the cell pointed to by the ref_text string
  • LOOKUP — contents of vector2 at the corresponding location to value in vector1
  • MATCH — the index of seek in vector
  • OFFSET — an offset cell range
  • ROW — vector of row numbers
  • ROWS — number of rows in reference
  • SHEET — sheet number of reference
  • SHEETS — number of sheets in reference
  • SORT — sorted list of numbers as vertical array
  • TRANSPOSE — the transpose of matrix
  • VLOOKUP — search the first column of range for value
XOR ADDRESS