Hi, I'm trying to fix an error on my NL Key function.
When I do not preface the filter reference cell with "@@" I get the error: The FilterField "Transaction No." has an empty Filter argument, which is not allowed.
When I do preface the filter reference cell with "@@" I get the error: Invalid filter "@@"
Formula is below. No issues with Document No. or Posting Date when I have added "@@" prefix, just seems to be an issue with the Transaction No.
=NL("Rows=2","G/L Entry",,"Document No.","@@"&AA11,"G/L Account No.",H11,"Posting Date","@@"&AB11,"Transaction No.","@@"&I11)
If anyone has a solution/workaround or can explain why the Transaction No. field is throwing up errors when the other filters are not I would greatly appreciate it.