[Solved] A better strategy for a fast VLOOKUP

[minamaestro2023kg]

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.

[tthompson41231]

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.

[minamaestro2023kg]

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