samedi 22 juin 2019

Google Sheets - match 2 conditions with REGEX, date and a word

I am trying to match one word and one date based on data from two cells in Google Sheets.

enter image description here

What I want to say is: If A1 matches Apple and B2 is 17.05.2019 then return MAY FRUIT

I am using REGEX as sometimes the text in A1 will be a partial match.

I am trying variations of this but to no avail:

=AND (REGEXMATCH(A1,"Apple"),(REGEXMATCH(A1,"Apple"),"MAY FRUIT"))

Aucun commentaire:

Enregistrer un commentaire