I have numeric values in column D, and text data in column H.

I want to return a list of all the D values, whenever "Word" appears in the corresponding row in column H.

I've tried:

=FILTER(D3:D,H3:H="Word")

Unfortunately not working, where am I going wrong?

Thanks

CodePudding user response：

Since Player's answer was basically the same as the question (as far as I could tell), I'll challenge the solution with this. Use this formula to evaluate if it contains WORD:

=filter(D3:D,ISNUMBER(find("WORD",UPPER(H3:H))))

See sample here.

CodePudding user response：

try:

=FILTER(D3:D; H3:H="Word")

update:

=FILTER(D3:D; REGEXMATCH(H3:H; "(?i)Word"))