# Getting the specific value by matching two values. (Vlookup)

**URL:** <https://community.thunkable.com/t/getting-the-specific-value-by-matching-two-values-vlookup/659176>\
**Category:** Questions about Thunkable X\
**Created:** [July 6, 2020, 8:19am UTC](https://community.thunkable.com/t/getting-the-specific-value-by-matching-two-values-vlookup/659176 "2020-07-06T08:19:03Z")\
**Posts on this page:** 4\
**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 6, 2020, 8:19am UTC](https://community.thunkable.com/t/getting-the-specific-value-by-matching-two-values-vlookup/659176/1 "2020-07-06T08:19:03Z")

</div>

Hello.  
I have a question about using Thunkable.  
Is there any way to use these data in Thunkable to find the specific value (“grade”) by matching two values (“Name” & “Subject”)?

For example:  
By inserting two values (“Jack” and “Biology”), getting the specific matched value which is “B”.

Thanks.

![Data1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/d/fd504f968bcca7ac130390f1b9477ad3e702134b.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 6, 2020, 11:01am UTC](https://community.thunkable.com/t/getting-the-specific-value-by-matching-two-values-vlookup/659176/2 "2020-07-06T11:01:37Z")

</div>

Hi @sooloni 👋

Here’s our tutorial for making your own VLOOKUP function:

> [@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 6, 2020, 12:28pm UTC](https://community.thunkable.com/t/getting-the-specific-value-by-matching-two-values-vlookup/659176/3 "2020-07-06T12:28:50Z")

</div>

Hi! 😃  
Thanks for your help.  
Unfortunately, I already tried that method and it didn’t work.

---

<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:25am UTC](https://community.thunkable.com/t/getting-the-specific-value-by-matching-two-values-vlookup/659176/4 "2024-11-08T11:25:05Z")

</div>