# How to use VLOOKUP in LocalDB without using a listviewer

**URL:** https://community.thunkable.com/t/how-to-use-vlookup-in-localdb-without-using-a-listviewer/1450395
**Category:** Questions about Thunkable X
**Created:** [August 15, 2021, 10:22am UTC](https://community.thunkable.com/t/how-to-use-vlookup-in-localdb-without-using-a-listviewer/1450395 "2021-08-15T10:22:13Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![dr.fadialhusbanfn](https://avatars.discourse-cdn.com/v4/letter/d/41988e/32.png) [@dr.fadialhusbanfn](https://community.thunkable.com/u/dr.fadialhusbanfn)
#### Post date: [August 15, 2021, 10:22am UTC](https://community.thunkable.com/t/how-to-use-vlookup-in-localdb-without-using-a-listviewer/1450395/1 "2021-08-15T10:22:13Z")

</div>

hello my friends,

I was trying to learn how to perform the VLOOKUP in localDB for the last 3 days, as shown in the tutorial: [Performing a VLOOKUP in LocalDB](https://community.thunkable.com/t/performing-a-vlookup-in-localdb/66057).  
but I am trying to change a label text to a random value in Column 1, and to change another label text to value in Column 2 (with the same index).  
without using a listviewer.

unfortiinatlly, the tutorial app is not functioning.

please note, the app in the pictures is just a test app, to help me understand the VLOOKUP function.

to add, my results were that one label gives me the last value in the (List) wich is 4 always, and the other label gives me randomized value from the (sublist).  
thank you all in advance.

 ![blocks](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/5/d5614891ba40b44e70036d56c5545efb855e63d3.png)  
 ![layout](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/3/a3df57ff9ba470be779a64c2d724a741c9e56eba.png)  
 ![table](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/a/0ab4fe81bcee86f3287f071301be44df3608ee9e.png)

---

<div class="post-metadata">

### Author: ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [August 15, 2021, 11:38am UTC](https://community.thunkable.com/t/how-to-use-vlookup-in-localdb-without-using-a-listviewer/1450395/2 "2021-08-15T11:38:53Z")

</div>

You problem is in “Result btn”. It is expecting a single number/text value but you are passing it a full list.

Let me advise you by first calling the function by passing it a direct number/string. Once you see it working then go to the next level and pass it the required number through the list

---

<div class="post-metadata">

### Author: ![dr.fadialhusbanfn](https://avatars.discourse-cdn.com/v4/letter/d/41988e/32.png) [@dr.fadialhusbanfn](https://community.thunkable.com/u/dr.fadialhusbanfn)
#### Post date: [August 15, 2021, 11:51am UTC](https://community.thunkable.com/t/how-to-use-vlookup-in-localdb-without-using-a-listviewer/1450395/3 "2021-08-15T11:51:40Z")

</div>

I really appreciate your response, I’ll try that and give you feedback.  
Thank you

---

<div class="post-metadata">

### Author: ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 1:17pm UTC](https://community.thunkable.com/t/how-to-use-vlookup-in-localdb-without-using-a-listviewer/1450395/4 "2024-11-08T13:17:23Z")

</div>