Guys, please help! :(((

Occasional Contributor

Guys, please help! :(((

I can't make a formula that would follow the following conditions:
If cell "B2" on sheet "A" equals the value of (isnumber(search("retarget";'A'!B2))) or (isnumber(search("rt";'A'!B2))) then "1", if not, then "2"

 

https://docs.google.com/spreadsheets/d/1KB5noJ40TNo8reTB-5jYaIS76zAINDnd/edit?usp=sharing&ouid=11759...

FORMULA AT LIST "B"

2 Replies
THANK YOU VERY MUTCH!!!!!

@artemkhorew 

Didn't check your file, better to attach it to the post. But it could be

=IF( isnumber(search("retarget";'A'!B2) ) + isnumber(search("rt";'A'!B2) ); 1; 2)