PROPERTY

Related Functions

• IF
  The IF function is a popular Sourcetable function that allows you to compare a value with what you expect that value to be.
• MATCH
  The MATCH function is used to search for a value in a range of cells and return the position of that value in the range. It does not return exact matches by default.
• INDEX
  The INDEX function allows users to return a value or reference to a value in a table or range.
• VLOOKUP
  The VLOOKUP function searches for items within tables and ranges by using a lookup value and then returning the exact or approximate match found.
• HLOOKUP
  The HLOOKUP function is used to search for a value in a table array and return a value from a different row in the same column. It is a useful tool for quickly finding data in large datasets.
• OFFSET
  The OFFSET function returns a reference to a range that is a set number of rows and columns from a cell or cell range.
• CHOOSE
  The CHOOSE function selects a value from a list of up to 254 value arguments using an index number.
• ADDRESS
  The ADDRESS function returns the address of a cell in a worksheet given the row and column numbers specified. It can also generate either an absolute or relative reference depending on the abs_num argument.
• GETPIVOTDATA
  The GETPIVOTDATA function is used to retrieve data from PivotTables, which is a Sourcetable table containing pivot rows and columns. This function takes three arguments, which specify the data to be retrieved, it can be a single cell or a list of cells.
• COLUMN
  The COLUMNS function returns the number of columns in a data set or reference by taking an array argument and a reference argument. The array argument is required and must be an array or array formula, while the reference argument is a range of cells to count the number of columns in.
• ROW
  The ROW function is a useful tool for finding the row number of a given reference. It takes an optional argument, named reference, which is the cell or cell range to get the row number for.
• INDIRECT
  The INDIRECT function allows users to create a reference to a cell given a text string, without having to manually change the cell references in the original formula.
• LOOKUP
  The LOOKUP function is a lookup function that searches for a value in a range by using the same position in another range.