Can you use a variable in the LOOKUP function for returnColumn?
I am having some trouble trying to use a variable as the returncolumn in a LOOKUP.
LOOKUP(lookupValue, tableName, lookupColumn, returnColumn)
I have a virtual column “DefaultTeam” that contains the name of a column in a table. Trying to use it like this:
LOOKUP([match], “Schedule”, “matchnum”, [DefaultTeam])
When I try this, Appshet errors stating that I need exactly 4 arguments. If I substitute [DefaultTeam] for a literal such as “Red1” it works fine.
Do you see any way to do this?