CountIf multiple conditions

[ashg657]

Hi all,
I have what seems to be a simple problem, but for some reason I cannot get
this
formulae to work....


=IF(AND(COUNTIF(Week1!$G$2:G11,Week2!G2)=0,(Week1!$B$2:B11,Week2!B2)=0,"No","Yes"))

I know I am doing something wrong but not sure what?! Probably me being
stupid and missing something simple here.

Thanks in advance!
Ash.

 

[Bob Umlas, Excel MVP]

=IF(AND(COUNTIF(Week1!$G$2:G11,Week2!G2)=0,COUNTIF(Week1!$B$2:B11,Week2!B2)=0),"No","Yes")
Bob Umlas
Excel MVP

 

[ashg657]

Great stuff, thanks Bob!
What I am trying to achieve is having 2 worksheets, one for Week1 and one
for Week2, In week 2 I have a list of amounts which i want to lookup on Week1
to see whether or not they existed in Week1, if they do then return "Yes"
else return a "No", Question is - this formulae will do the job yes? If not
could you point me in the right direction? Many thanks.