0

Excel function within NL - Filter

Hi,

 

I'm sure this is really simple, but having a major senior moment.

I'm trying to retrieve data from one table, but filtered using data from another table. Usually pretty simple using NL("Filter"....

However, I would like to filter on the first 6 characters of a field.

In SQL : Select Field From Table1 Where Left(Field,6) in (Select Field2 From Table2)

I've tried various methods of getting the LEFT(Field,6) bit to work but so far to no avail.eg. NL("Rows","Table1","Field","LEFT(Field,6)",NL("Filter","Table2","Field2")

Any help would be much appreciated.

 

Thanks,

Wilf

7 comments

Please sign in to leave a comment.