Looking 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 !!!!!

[John Coleman]

Decreenisi wrote:
> 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 !!!!!

Maybe

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

in M2

Hope that helps

-John Coleman

[Decreenisi]

John,

Thanks mate, just the job !!

[Bob Phillips]

Please restrict yourself to one posting, you waste people's time otherwise.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Decreenisi" <[email protected]> wrote in message
news:[email protected]...
> 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 !!!!!
>