Excel If Match String, Use exact cell comparison, VLOOKUP to find missing text, and formulas for partial matches.