-SCS Parameter Analyzer Reference Manual Section 6:
4200A-901-01 Rev. C / February 2017 6-283
LOOKUP Calc worksheet function
This command searches for a value in one range and returns the contents of the corresponding position in a
second range.
Usage
LOOKUP (Lookup_value, Lookup_range, Result_range)
The value for which to search in the first range
The first range to search and contains only one row or one column; the range can
contain numbers, text or logical values; to search Lookup_range, the expression
in the range must be placed in ascending order (for example −2, −1, 0, 2 ... A
through Z, False, True); the search is not case sensitive
Range of one row or one column that is the same size as the Lookup_range
Details
If Lookup_value does not have an exact match in Lookup_range, the largest value that is less
than or equal to Lookup_value is found, and the corresponding position in Lookup_range is
returned. When Lookup_value does not exist or is smaller than the data in Lookup_range, #N/A
is returned.
Example
The following examples refer to the Calc worksheet cells illustrated below (these cells were linked to
a Run worksheet; refer to Link Run and Settings worksheet cells to Calc worksheet cells (on page
6-
186)).
Figure 386: Example Calc worksheet cells
=LOOKUP (0.5, A2:A8, B2:B8)
=LOOKUP (0.4, A2:A8, B2:B8)
=LOOKUP (-0.1, A2:A8, B2:B8)
Returns -0.003683852.
Returns -0.0023773371 (see Details).
Returns #N/A (see Details).
Also see
MATCH (on page 6-284)
To Next Page
Loading...
Need help?
General
