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

see 2 responses you have in public.excel

--
Regards

Roger Govier


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

and those in .programming!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Roger Govier" wrote in message
...
see 2 responses you have in public.excel

--
Regards

Roger Govier


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