You can define an Excel range or named range as a table source for the NL function, but there is no way to filter on that range. By parsing the number of columns in the table range, you could expose an implicit fields list ColA, ColB, ColC, etc and then filter within the appropriate column as an offset. If the NL table is defined with a named range, then the name range name could be used and would implicitly point to ColA. 

Actually, since the columns are relative to the range, the implicit list should probably be named something like RangeCol1, RangeCol2, ..., RangeColN to avoid confusion with sheet range that was selected.