CODEWITHSUNDEEP
if-statementgoogle-sheetsexcel-formulamatchtextmatching
user16239103
user16239103

Reputation:

If text match in range conditonal formula Google Sheets error

I'm trying to get a match in a range of text in Google Sheets basically I'm using this formula:

=IF(REGEXMATCH(H2:M2, "Hi"), "Yes", "No")

But I'm getting an error that is:

enter image description here

Upvotes: 0

Views: 61

Answers (1)

z..
z..

Reputation: 12803

You are referencing an array in a function that is not designed to take arrays as input so you need to enable them.

Try:

=ArrayFormula(IF(REGEXMATCH(H2:M2, "Hi"), "Yes", "No"))

I'm trying to do this: =IF(("Hi"=H2:L2),"Approve","No qualify") =IF(("Here"= H2:L2),"Approve","No qualify")

Assuming E1:E2 is the list of values to check against A1:C1, you can try:

=ArrayFormula(if(countif(E1:E2,A1:C1),"Approved","Not qualified"))

enter image description here

Upvotes: 1

Related Questions