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

(SmartD) #1

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.

(Tony Fader) #2

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

(SmartD) #3

Thanks

@tony