Excel 2007 : Excel Search Question

[wraith1385]

Hello, I have a worksheet that is very dynamic and I'm having trouble coming up with a workable search function that is a requirement for another project.

I need a search that finds value "AAAA" column C and then returns true if there is "x" in column E on the same row.

The problem is that there could be multiple rows that have AAAA in column C and so if there is not an x in column E, then I need it to keep searching and check the other rows.

I've fried my head thinking about how to do it, so I came here hoping that new eyes on the problem would provide a solution.

[jacqueslegrand]

Maybe in another column, with the condition AND(C1="AAAA";E1=x")

[SCLai]

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

[wraith1385]

Sorry, I think I left out some information. I'm searching from another workbook and basically I need to return true or something if somewhere on the first sheet there is a row where AAAA is in column c and x is in column e. I also have to do this for other values similar to AAAA.