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!

​HiI 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!  Read More

​