Understanding LOOKUPVALUE
The LOOKUPVALUE function retrieves values from a table in a simple way, but it involves a hidden level of complexity. This article provides full coverage of the LOOKUPVALUE internals, alongside several performance considerations.
If you are searching for an introduction of LOOKUPVALUE, please read the Introducing LOOKUPVALUE article first. Here, we assume that the reader is familiar with the LOOKUPVALUE semantics.