1.The IF function does not support wildcards. instead you can use something like=IF(ISNUMBER(search("*"&your_string&"*",cell-nr)),...
2. Your INDEX formulas do not have the match_type (the default is 1 when omitted) so they will not return exact matches ( maybe that is what you want?)