Hello,
I have the formula: =IF(INDEX('4WK MVT'!B:B,MATCH('Worksheet'!C12,'4WK MVT'!D:D,0))="*"&"DC"&"*",True,False)
The end goal here is if the returned result has "DC" in it, I want it to the True, if not, False.
Pretty sure I am using the wildcard incorrectly or something. Thank you!
I have the formula: =IF(INDEX('4WK MVT'!B:B,MATCH('Worksheet'!C12,'4WK MVT'!D:D,0))="*"&"DC"&"*",True,False)
The end goal here is if the returned result has "DC" in it, I want it to the True, if not, False.
Pretty sure I am using the wildcard incorrectly or something. Thank you!