lookup function

[adhie]

hello I have a question, I have two table in appsheet, one for input and one for Data
table one (Data) consist of:
Material Name, Material Position, and Material Stock

table two (Input) consist of:

Material Name, Material Position, and Material Stock

I want to it to automatically input the material stock in the second table if the material name and position that I inputed matches the first table.

I tried using this formula but it is not applicable, any help??

LOOKUP(
[_THISROW].[ColumnA] & [_THISROW].[ColumnB],
'TableB',
'ColumnA' & 'ColumnB',
'ColumnC'
)

[AleksiAlkio]

Write it like..
ANY(SELECT(Data[Material Stock],
AND(
[Material Name]=[_THISROW].[Material Name],
[Material Position]=[_THISROW].[Material Position]
)
))