Dec 17 2021 12:34 PM
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"
FORMULA AT LIST "B"
Dec 18 2021 05:22 AM
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)