[Solved] A better strategy for a fast VLOOKUP

Due to my work need, I’m using the current blocks to perform a VLOOKUP, it works fine but it’s very slow as the blocks has to loop throw 14k of rows to get the desired value which takes about a couple of Seconds,


I tried both local data source and google sheet without a difference as both of them are uncomfortably slow.
Any better strategy is available for an instant result.

1 Like

Try this. Set the columns to app variables when the screen starts then find your value with the list blocks as shown. Let me know if that speeds it up.

2 Likes

@tthompson41231
Yes, those blocks really solved the problem and enhanced the speed with instant result.
Really an ingenious yet simple strategy.

1 Like