[Solved] Need some help with VLookup

[sooloni]

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.

[domhnallohanlon]

Hey @sooloni

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

Performing a VLOOKUP in LocalDB

One of the most powerful features in Thunkable is the new LocalDB 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. What is VLOOKUP? A VLOOKUP, or vertical lookup, allows you to search vertically down through a column of data and then find a corresponding value in your target row Design Let’s start…

[sooloni]

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.

[actech]

Check it

https://x.thunkable.com/projects/5f19726d3063c87368b8c8dc/project/properties/designer

[domhnallohanlon]

@sooloni does the sample project above work for you?

[sooloni]

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

[sooloni]

Yes. The sample project works great.
Thanks!