# \[Solved\] Need some help with VLookup

**URL:** <https://community.thunkable.com/t/solved-need-some-help-with-vlookup/669436>\
**Category:** Questions about Thunkable X\
**Tags:** solved\
**Created:** [July 10, 2020, 8:09am UTC](https://community.thunkable.com/t/solved-need-some-help-with-vlookup/669436 "2020-07-10T08:09:10Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![sooloni](https://avatars.discourse-cdn.com/v4/letter/s/3da27b/32.png) [@sooloni](https://community.thunkable.com/u/sooloni)\
**Post date:** [July 10, 2020, 8:09am UTC](https://community.thunkable.com/t/solved-need-some-help-with-vlookup/669436/1 "2020-07-10T08:09:10Z")

</div>

Hi.  
I need some help to build the blocks to get the specific value (“grade”) by matching two values (“Name” & “Subject”).  
Currently, I am using two individual ‘ListViwer’ to show each variable (“Name” & “Subject”) and my data is in the LocalDB.  
This is what I have done so far, but it still does not work.  
So please anyone help me to fix my blocks.  
Thanks in advance.

![Screen1-1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/d/6d82e461127d078813322fd9f208a22d2ee9b055.png)

![Screen1-Data](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/8/58e869ac8b315e467d1b6c3b4d3de6fe621a25fa.png)

 ![Screen1-Blocks](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/1/b100afa5e570cb66163017eeec0a092b085ca3f3.png)

---

<div class="post-metadata">

**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\
**Post date:** [July 10, 2020, 11:16am UTC](https://community.thunkable.com/t/solved-need-some-help-with-vlookup/669436/2 "2020-07-10T11:16:30Z")

</div>

Hey @sooloni

Was there anything in the VLOOKUP tutorial that you can use as a reference?

> [@Performing a VLOOKUP in LocalDB](http://community.thunkable.com/t/performing-a-vlookup-in-localdb/66057):
>
> One of the most powerful features in Thunkable is the new [LocalDB](https://docs.thunkable.com/thunkable-cross-platform/create/components/data/local-db) component, which allows you to insert a mini-spreadsheet directly into your app. This might be the first of a larger series of tutorials mimicking features found in other spreadsheets, but for now let’s get started with VLOOKUP. question What is VLOOKUP? A [VLOOKUP](https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1), or vertical lookup, allows you to search vertically down through a column of data and then find a corresponding value in your target row art Design Let’s start…

---

<div class="post-metadata">

**Author:** ![sooloni](https://avatars.discourse-cdn.com/v4/letter/s/3da27b/32.png) [@sooloni](https://community.thunkable.com/u/sooloni)\
**Post date:** [July 23, 2020, 10:34am UTC](https://community.thunkable.com/t/solved-need-some-help-with-vlookup/669436/3 "2020-07-23T10:34:42Z")

</div>

Hi 👋

Thanks for your response.

I kept trying to learn the method to do Vlookup with your instructions, but I still haven’t figure out how to do VlookUp with two separate variables.

As I already spent almost 3 weeks to figure out how to do Vlookup with two different variables, I guess I should just give up.

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [July 23, 2020, 11:48am UTC](https://community.thunkable.com/t/solved-need-some-help-with-vlookup/669436/4 "2020-07-23T11:48:56Z")

</div>

Check it

[https://x.thunkable.com/projects/5f19726d3063c87368b8c8dc/project/properties/designer](https://x.thunkable.com/projects/5f19726d3063c87368b8c8dc/project/properties/designer)

---

<div class="post-metadata">

**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\
**Post date:** [July 24, 2020, 3:52pm UTC](https://community.thunkable.com/t/solved-need-some-help-with-vlookup/669436/5 "2020-07-24T15:52:10Z")

</div>

@sooloni does the sample project above work for you?

---

<div class="post-metadata">

**Author:** ![sooloni](https://avatars.discourse-cdn.com/v4/letter/s/3da27b/32.png) [@sooloni](https://community.thunkable.com/u/sooloni)\
**Post date:** [July 24, 2020, 4:05pm UTC](https://community.thunkable.com/t/solved-need-some-help-with-vlookup/669436/6 "2020-07-24T16:05:57Z")

</div>

Thank you so much! 😄  
Finally, I learned how to do the VlookUp (with two separate variables) in Thunkable.

---

<div class="post-metadata">

**Author:** ![sooloni](https://avatars.discourse-cdn.com/v4/letter/s/3da27b/32.png) [@sooloni](https://community.thunkable.com/u/sooloni)\
**Post date:** [July 24, 2020, 4:06pm UTC](https://community.thunkable.com/t/solved-need-some-help-with-vlookup/669436/7 "2020-07-24T16:06:56Z")

</div>

Yes. The sample project works great.  
Thanks! 😃

---

<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, 11:24am UTC](https://community.thunkable.com/t/solved-need-some-help-with-vlookup/669436/8 "2024-11-08T11:24:11Z")

</div>


