# Returning a Value

**URL:** https://community.thunkable.com/t/returning-a-value/2858476
**Category:** Questions about Thunkable X
**Tags:** beginner, help, google-sheets
**Created:** [February 26, 2024, 11:42pm UTC](https://community.thunkable.com/t/returning-a-value/2858476 "2024-02-26T23:42:54Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![briseno1984q](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/briseno1984q/32/135250_2.png) [@briseno1984q](https://community.thunkable.com/u/briseno1984q)
#### Post date: [February 26, 2024, 11:42pm UTC](https://community.thunkable.com/t/returning-a-value/2858476/1 "2024-02-26T23:42:54Z")

</div>

Hello Everyone… first post here.  
I am making a “Sign in, Sign Out” Hall Pass App.  
Students enter their ID Number ----\> Google Sheet will record: Name, Time, Teacher, Location etc.

I am having issues returning a student name based on them entering their ID Number.  
This is what I have, and for the life of me it is not returning anything.

**I have tried:**  
Initialing a list with "list of values in 2023-2024 in Sheet 1 in ID Number  
Assigning variables for the index and using “list of values in 2023…, this lead to my app crashing.  
I tried creating a list from text with the " ,”, but that also ended up crashing my app and giving me the “check blocks error”  
I know that it will return a name if i put a specific number for the row id.

But when I don’t, the Index always returns 0.

 ![Screenshot 2024-02-26 at 3.33.31 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/e/ce8fa2ee39e81fad696c7682d61e1a18a0ceec42.png)

I created a similar app a while back and used the Create object Json text to post on a Google sheet and it worked fine.  
Please help. I have a list of 700 if that makes a difference.

---

<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 27, 2024, 12:39am UTC](https://community.thunkable.com/t/returning-a-value/2858476/3 "2024-02-27T00:39:11Z")

</div>

Hi and welcome to the Thunkable forums!

There is a problem with the way you are using variable blocks. Please see this topic and let me know if you have any questions after that: [Setting and Getting Stored Variables - Keep getting Null](https://community.thunkable.com/t/setting-and-getting-stored-variables-keep-getting-null/2856079)

Your question seems to be how to do a _vlookup_. This question comes up frequently on the forums and I would encourage you to search for that term if you haven’t yet.

---

<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 27, 2024, 12:39am UTC](https://community.thunkable.com/t/returning-a-value/2858476/4 "2024-05-27T00:39:25Z")

</div>

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