Question: I am trying to format a moment date and compare. I know the below is not valid.
How can i do both at the same time?

```
moment('value'). format('MM/DD/YYYY). isSame ( moment ('value). format('MM/DD/YYYT')

```

Answer: 
use:

```
=ARRAYFORMULA(IFNA(REGEXEXTRACT(B1:B, TEXTJOIN("|", 1, A1:A))))

```

[![enter image description here](https://i.stack.imgur.com/ATmeQ.png)](https://i.stack.imgur.com/ATmeQ.png)
I used this method (though I am a little unclear of your exact requirement - is it the corresponding column A, or if the thing is contained, return it if it's in column A as well?):

```
=IF(REGEXMATCH(C2,"(?i)"&B2),A2,"No Match")

```

The "?i" in the regular expression is to make it case insensitive when searching as shown in the last line.

[![example](https://i.stack.imgur.com/2FThF.png)](https://i.stack.imgur.com/2FThF.png)