What is the quickest / most efficient formula to lookup a value in another table for a virtual column? I have used lookup() and any(select()) to accomplish this.
Thanks
Kyle
Hi @tcpallet ,
This post will be of interest to you : https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-FILTER-LOOKUP-MAXROW-MINROW-REF-ROWS-and-SEL...
thanks!
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |