The following NL returns a #VALUE! Error when referencing a range of Cells (The cell range below in Bold text)
=NL("Sum","Sales Line","Line Amount Ex. Tax","Document No.",H27:J27,"Description","<>**Chime**","Show End Date",$Z$10)
The Range it is referring to is another NL.
=NL("Columns","Sales Line","Document No.","Show End Date","01/04/2021..30/04/2021","Description","<>' '","Line Amount Ex. Tax",">0","Transaction Type","EVTYPE31")
This second NL returns a column of Document No. s, the first value returns like this:
Cell H27 - RO001856
The subsequent values return like this:
Cell I27 ="SQ000735"
Cell J27 ="SQ000737"
I don't know if the #VALUE! error is because of the format of the Cell range in the first NL or because the values in I27 & J27 have the =" " as to which I don't know why they return like that?
The second NL could be rows or columns but the same error returns regardless.
Note if I was just to type in the document numbers as hard text with the same cell range there is no #VALUE ERROR!.