Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference LOOKUP
Functions and Expressions Reference Guide
147
LOOKUP performs a sequential search over series_to_search. Use LOOKUP if
series_to_search is not ordered. Using
SEARCHUP when that series is in ASCII
ascending order or
SEARCHDOWN when that series is in ASCII descending order
can save time if the series being searched is large.
LOOKUP differs from EXTRACT in that LOOKUP returns the first member of
series_to_search that meets the condition_to_evaluate, while
EXTRACT returns
all members (one at a time) of series_to_search that meet the
condition_to_evaluate.
Related Functions
CHOOSE, EXTRACT, SEARCHUP, SEARCHDOWN