Stuck on formula

[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]

See response in public.excel

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)