I am trying to match one word and one date based on data from two cells in Google Sheets.
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