How to get value by specific key in 2 table?

Muhammad_irfan_Tkj · October 21, 2023, 9:25am

Can someone help me? I would really appreciate it.

I have 2 table.
First tab contains ID and name.
Second tab contain ID and the value
So I want to get the same data from the first tab based on ID in the second tab

example. i have this table
table 2
and the second table
table 1

look at the table, i want to get value “pena” based on he’s id value = “15.” can someone tell me how?

Kakashi · October 21, 2023, 11:58am

use index in list thing list

Still-learning · October 21, 2023, 2:22pm

you can use filter by formula method. already method is suggsted in community