=IF(AND) ASSISTANCE

V

VAN GOGH

Why doesn't this formula work?

=IF(AND('Detail by POG'!D1:D1000="Mainline Books - 12.5'",'Totals
Only'!B3='Detail by POG'!B1:B1000),"YES","NO")

Thanks.
 
B

Bob Phillips

Spurious apostrophe.

=IF(AND('Detail By POG'!D1:D1000="Mainline Books - 12.5",'Totals
Only'!B3='Detail By POG'!B1:B1000),"YES","NO")

But this onl;y tests the first cell, do you want any instance of that text
to register yes, if so

=IF(OR(ISNA(MATCH("Mainline Books - 12.5",'Detail By
POG'!D1:D100,0)),ISNA(MATCH('Totals Only'!B3,'Detail By
POG'!B1:B1000,0))),"NO","YES")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
M

Marcelo

Hi,

try this

=IF(AND(SUMPRODUCT(--('Detail by POG'!D1:D1000="Mainline Books -
12.5'")),SUMPRODUCT(--('Detail by POG'!B1:B1000='Totals
Only'!B3))),"YES","NO")

HTH
Regards from Brazil - going to the 6th *
Marcelo

"VAN GOGH" escreveu:
 
J

JMB

Or does he want to know if the two criteria appear in the same row?

=IF(SUMPRODUCT(--('Detail by POG'!D1:D1000="Mainline Books -
12.5'"), --('Detail by POG'!B1:B1000='Totals
Only'!B3)),"YES","NO")

To respond to the OP's question of why it does not work - not easy to answer
when you don't tell anyone what you are trying to do.
 
Top