This article provides full coverage of the LOOKUPVALUE internals, alongside several performance considerations.
Related article
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.
Read related article