Lookup a virtual column from another app

[duanehumphreys]

Is it possible to lookup a virtual column in one app from another app? I've had a look at LINKTOROW which allows me to link to the correct row, but I can't see a way to lookup a value within that row. It seems like there should be a way to do it using the LOOKUP functionality, but I've not managed to find anything that works.

[JSO]

Maybe LOOKUP() works better for you.
https://support.google.com/appsheet/answer/10107410?hl=en&sjid=13821535674502480582-EU

[duanehumphreys]

How would I reference the other app though? Is there some way of including the app ID in the 'reference' part of the syntax?

[JSO]

It is not contemplated.
Note that this expression is a Search in data expression, not search in applications.
If you have access to it, incorporate the Table where you are going to search for data into your application.