Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

lookupvalue linked tables

Hi,   Please can you tell me how to do a lookupvalue function that returns a value from another (linked) table? The below test code doesn't work. A workaround is to create a column called "Name" in...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Anonymous

 

Normally the first 2 arguments of LOOKUPVALUE are from the same table

=LOOKUPVALUE(products[Name],transactions[ProductID],"12345678")

 

So may be try this

 

=
LOOKUPVALUE ( products[Name], products[ProductID], "12345678" )