# Speed-up Vlookup

**URL:** <https://community.thunkable.com/t/speed-up-vlookup/2818626>\
**Category:** Questions about Thunkable X\
**Tags:** help\
**Created:** [February 4, 2024, 7:06am UTC](https://community.thunkable.com/t/speed-up-vlookup/2818626 "2024-02-04T07:06:57Z")\
**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:** [February 4, 2024, 7:06am UTC](https://community.thunkable.com/t/speed-up-vlookup/2818626/1 "2024-02-04T07:06:57Z")

</div>

the following blocks are used with the barcode scanner to be able convert the expiry date reading format from the generic (for example 0625) to JUN - 2025 with separating the expiry year and month so I can set 2 labels for month and year.

 ![Screenshot 2024-02-04 085959](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/1/51925be0e553e50a816ff7706392a8b656ab8cad.png)  
those blocks are working fine except for having a lag between the code to get the year and the one to get the month as the steps to get the month are a little bit longer.  
Are there a better and faster way to do it, so I get both results simultaneously.

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [February 4, 2024, 7:22am UTC](https://community.thunkable.com/t/speed-up-vlookup/2818626/2 "2024-02-04T07:22:58Z")

</div>

That looks pretty efficient but I would think it might be quicker to use a Get Value block instead of the outer List of Values block.

---

<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:** [February 9, 2024, 9:08am UTC](https://community.thunkable.com/t/speed-up-vlookup/2818626/3 "2024-02-09T09:08:09Z")

</div>

I think the get value block will cause more lag, isn’t it ?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [May 9, 2024, 9:08am UTC](https://community.thunkable.com/t/speed-up-vlookup/2818626/4 "2024-05-09T09:08:15Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.