FILTER not returning matches

[tlconnors001]

Hi

I am looking for assistance with creating a formula that checks the values of column "D" for a specific text "Flexi Day" and then returns the value in column "B" (staff name) for all of the matches.

I used the formula:  =FILTER('Term 4'!D4:D36,'Term 4'!B4:B36=E1) where E1 is text in a cell that says "Flexi Day".

It is returning Error No matches are found in FILTER evaluation.  There is a match in D4.

The data in column D is from a drop down list.  I thought this may be the issue, but I inserted "Flexi Day" into a cell in column D that is not a drop down, and it still shows no matches.

Is the issue that the data is from a different worksheet within the same document?

I can't use VLOOKUP because the columns are back to front, and I tried XLOOKUP and some other things, and nothing is working and Google is not helping either.

Hoping that someone can assist.

Thank you!

[#2]

@tlconnors001 

If "Flexi Day" is in column D then it should be:

=FILTER(...,'Term 4'!D4:D36=E1) 

[#3]

@tlconnors001 

It looks like your parameters are the wrong way round.  This might be far clearer if you used defined names.

= FILTER(Names, type="Flexi day")

= FILTER(type, Names="Flexi day")

 Unless you have an employee that goes by the name of "Flexi Day" the latter will not give matches!