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.