Dear Community: I will appreciate your help w...

Dear Community: I will appreciate your help with this issue. I am trying to use an app formula nesting 2 funtions LOOKUP: LOOKUP(match-value, table-name, match-column, LOOKUP(match-value2, table-name2, match-column2, return-column2)) But the platform throws the following error: Function ‘LOOKUP’ should have exactly four parameters: LOOKUP(lookupValue, tableName, lookupColumn, returnColumn)

Someone knows how to include the fourth parameter with formula?

Thanks in advance.

0 2 376
2 REPLIES 2

tony1
New Member

@SmartD The final three arguments to the LOOKUP function must be constant values, and cannot be formulas.

Thanks

@tony

Top Labels in this Space