the first query puts into query new field ThisIsMyField1: NZ([Field1],"NE")
the second query will do reg. lookup (lookup table has to have valid value for NE ---> NonEnglish
2. the second easier solution uses only one query
instead of showing Lookup Value for Field1, use this
FinalValue: NZ([LookupforField1],"Non English")
although the second version is easier and you will probably use it, it is sometimes better to use first version - lookup table has really ALL possible values.... this is good for Warehousing - there is no space for NULL values (sometimes).....
note: as you can see, I did not follow your task. My version is based on NULL values, not BLANK values.... I guess you ment NULL not BLANK
for combination of NULL or BLANKS it would look like this: