Loking for the truth

[Decreenisi]

I am creating a spreadsheet to track rejects.
cell L2 has the following code =IF(I6>0,ISNA(MATCH('Ticket
Query'!$I6,'Ticket Query'!$B$6:'Ticket Query'!$B$1000,FALSE)),""). This
returns a value of True or False.
Cell J2 has a response I.D of either AF, CON, NFF
I want a code in Cell M2 to look cell L2, if that has a value of TRUE,
then to look at Cell J2, if that has either AF, CON, or NFF. Then it
returns a value of TRUE

Anyone any ideas !!!!!

 

[Bob Phillips]

=AND(L2,ISNUMBER(MATCH(J2,{"AF","CON","NFF"},0)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Roger Govier]

Hi

Try
=IF(AND(OR(J2="AF",J2="CON",J2="NFF"),L2=TRUE),"TRUE","FALSE")

Incidentally the following
=IF(I6>0,ISNA(MATCH('Ticket Query'!$I6,'Ticket Query'!$B$6:'Ticket
Query'!$B$1000,FALSE)),"")
could be simplified to
=IF(I6>0,ISNA(MATCH('Ticket Query'!$I6,'Ticket
Query'!$B$6:$B$1000,FALSE)),"")
you don't need to specify the Sheet name twice in defining the range.