This function returns the relative position of a specified item in a range
- Library: PQL \ Spreadsheet \ Lookup
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
- Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions
Value to search for
Range to search in
Value to return if the formula returns an error. Can be 0 (first value that is equal to value), 1 (largest value that is less than or equal to value), or -1 (smallest value that is greater than or equal to value)
This function is the same as the Microsoft Excel 'MATCH' function - using the same inputs, logic and outputs.