Hi All,

I was trying to get some value using Match and If function, in this i have a doubt and clarify me how it can be done.

My question is if i have some text values from A1 to A5.

BOX
CYCLE A
RUBBER S: GHY
TEXT
HURTY

I need to check a condition from A1 to A5 whether it met that condition.

My formula is =If(A1:A5="RUBBER S: GHY",1,0) and its showing wrong answer or error.

I think am clear in my question. Waiting for reply. Thanks.