Excel 2007 : Excel Search Question

To elaborate on jacques's point, please try this formula at your destinated cell, e.g F1 if your data is in C1 and E1:
=IF(AND(C1="*AAAA*",E1="X"),"Match","")
The formula will search if the cell C1 contains "AAAA", E1 is exactly "X". If both true, returns "Match" as output

Or you can use this:
=IF(AND(C1="AAAA",E1="X"),"Match","")
The formula will search if the cell C1 is exactly "AAAA", E1 is exactly "X". If both true, returns "Match" as output

Hope this is what you wanted!

SC