If And Then Formula question/issue

[pbajeff29]

I have a spreadsheet that I am needing to build formulas on. I have 3 qualifiers that need to be validated across a range. So the formula needs to first look in Column A on "Data" sheet and see is data in cell A1 exists AND look in Column E on "Data" sheet and see if data in cell A3 exists within the group that were identified through the first lookup AND look in Column B on "Data" sheet and see if data in B1 exists within the group that was identified through the first two lookups. Below is the formula I tried, but it is returning complete when not all 3 conditions are met. It has to go in order and look at the subset of results each step of the formula.

=IF(AND(COUNTIF(Data!$A:$A.$A$1)>0,COUNTIF(DATA!$E$E,$A$3)>0,COUNTIF(DATA!$B$B,$B$1)>0."Complete","Not Complete")

 

[Fluff]

Duplicate to: Formula Help

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.