Rounds down a single number to the nearest specified value, usually to a whole number.
Looks up a range and returns the first corresponding value in a vertical table that matches exactly the specified input.
Looks up a range and returns the first corresponding value in a horizontal table that matches exactly the specified input. An error is returned if it cannot find the exact match.
Works like the coordinates of a map and returns a single value based on the column and row numbers you input into the function fields.
Returns the position of a value in a column or a row. Modelers often combine MATCH with the INDEX function to create a lookup function, which is far more robust and flexible and uses less memory than the VLOOKUP or HLOOKUP.