This function searches for a value and returns a value from the same location in a second area
- Library: PQL \ Spreadsheet \ Lookup
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Value for which to search; can be number, text, logical value, or name or reference that refers to a value
Cell range that contains one row or one column; can be text, numbers, or a logical value; values need to be in ascending order
Cell range that contains one row or column; must be the same size as lookup vector
This function is the same as the Microsoft Excel 'LOOKUP' function - using the same inputs, logic and outputs.