Model 4200A-SCS Parameter Analyzer Reference Manual
Section 6: Clarius
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
)
Lookup_value
The value for which to search in the first range
Lookup_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
Result_range
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-
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
.
R
eturns
-0.0023773371
(see
Details
).
Returns
#N/A
(see
Details
).
Also see