# \[Solved\] A better strategy for a fast VLOOKUP

**URL:** <https://community.thunkable.com/t/solved-a-better-strategy-for-a-fast-vlookup/2651442>\
**Category:** Questions about Thunkable X\
**Created:** [October 18, 2023, 5:44pm UTC](https://community.thunkable.com/t/solved-a-better-strategy-for-a-fast-vlookup/2651442 "2023-10-18T17:44:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![minamaestro2023kg](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@minamaestro2023kg](https://community.thunkable.com/u/minamaestro2023kg)\
**Post date:** [October 18, 2023, 5:44pm UTC](https://community.thunkable.com/t/solved-a-better-strategy-for-a-fast-vlookup/2651442/1 "2023-10-18T17:44:20Z")

</div>

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,

 ![Screenshot 2023-10-18 203816](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/a/5ab027584f771c1225ab3db1a253ce7c29920f7d.png)  
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.

---

<div class="post-metadata">

**Author:** ![tthompson41231](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tthompson41231/32/161401_2.png) [@tthompson41231](https://community.thunkable.com/u/tthompson41231)\
**Post date:** [October 18, 2023, 7:00pm UTC](https://community.thunkable.com/t/solved-a-better-strategy-for-a-fast-vlookup/2651442/2 "2023-10-18T19:00:09Z")

</div>

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.

 ![Example 2](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/a/4a7be885114e8547b279c5bb87ed190998a9475d.png)

---

<div class="post-metadata">

**Author:** ![minamaestro2023kg](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@minamaestro2023kg](https://community.thunkable.com/u/minamaestro2023kg)\
**Post date:** [October 20, 2023, 8:13am UTC](https://community.thunkable.com/t/solved-a-better-strategy-for-a-fast-vlookup/2651442/3 "2023-10-20T08:13:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![matt\_conroy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/matt_conroy/32/150843_2.png) [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)\
**Post date:** [October 20, 2023, 3:42pm UTC](https://community.thunkable.com/t/solved-a-better-strategy-for-a-fast-vlookup/2651442/4 "2023-10-20T15:42:49Z")

</div>