This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Efficient lookup formula

Posted on 02-04-2022 11:11 AM
tcpallet
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

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

0 2 46
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
lamontfr
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

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... 

Posted on --/--/---- --:-- AM
tcpallet
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

thanks!

Top Labels in this Space