Index/Match Partial Match

[temerson]

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!

 

[temerson]

Found the solution. No answer needed.

=IF(ISNUMBER(SEARCH("DC",INDEX('4WK MVT'!B:B,MATCH('Dairy Allocation Worksheet'!C12,'4WK MVT'!D:D,0)))),"DC",INDEX('4WK MVT'!B:B,MATCH('Dairy Allocation Worksheet'!C12,'4WK MVT'!D:D,0)))

using ISNUMBER and SEARCH to find the value, then return what I want.