LOOKUP vs SELECT and efficiency

[leonrothenberg]

Hi all - just 2 style/clarification questions about overlapping functionality:

LOOKUP() vs. SELECT() ?

INDEX(SELECT( … ), 1) vs ANY(SELECT( … )) when you’re sure there’s only one result, and it needs to be typecast as its type, not as a returned LIST.

Interested in some guidance both in efficiency and best use cases. Any advice appreciated.

Thx!

[Steve (Steve Coile)]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()

How are FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() related? FILTER(), LOOKUP(), MAXROW(), and MINROW() are all built upon SELECT(), so they all share similar capabilities and limitations. FILTER("table", select-expression) is equivalent to: SELECT( table[key-column], (select-expression) ) LOOKUP(match-expression, "table", "match-column", "result-column") is equivalent to: ANY( SELECT( table[result-column], ([match-column] = (match-expression)) ) ) N…

[Marc_Dillon]

I’d assume ANY(…) and INDEX(…,1) are equivalent in performance, if that is what you’re asking.