the Query function seems to not react well to different data types in 1 column, it seems All rows of col B are numbers except for the technicians
I put in your file a second set of same data where the ID is formatted as plain text for all rows an then if you use the query function it will show T-01
The filter function also shows results with mixed datatypes
Also importrange is not required for references inside the same sheet, common reference as used in filter function also works but you do need to change the col references in the select section to the actual column letters.
the formule then looks like this
All formulas are in added to your testfile so no need to upload a doc or new link..
Bookmarks