I am creating a spreadsheet to track rejects.
cell L2 has the following code =IF(I60,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 !!!!!

Decreenisi wrote:
I am creating a spreadsheet to track rejects.
cell L2 has the following code =IF(I60,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

John,

Thanks mate, just the job !!

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Decreenisi" wrote in message
oups.com...
I am creating a spreadsheet to track rejects.
cell L2 has the following code =IF(I60,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 !!!!!