Thanks Biff that works fine.

Regards Bob
"Biff" wrote in message
...
Hi!

Try reversing the conditions:

=IF('Data
Entry'!B33="ASA12346","YES",IF(OR(INDEX(Sheet1!C:C ,MATCH(B7,Sheet1!A:A,0))={"ASA","GIG"}),"NO","YES" ))

Biff

"dbl" wrote in message
...
Biff there is one policy number (ASA123456) which is different from the
rest

ASA is "NO" apart from the above which is "YES" so I cannot in this case
use the ASA part of the policy number.

The formula you have sent works in all scenarios apart from returning
"NO" for the above policy which should be "YES".

Is this because it picks up the ASA part in the formula and is then not
over ridden by the last part? I also take it that the last "YES" is the
answer if it finds none of the above? which is how it should work.

Thanks for your help.

Bob

"Biff" wrote in message
...
Hi!

Adding this part:

If the above also ="GIG", "NO","YES"

is no problem but you need to explain further how this part fits:

Plus if cell B33="ASA123456","YES","YES"

Unless it's a separate test:

=IF(OR(INDEX(Sheet1!C:C,MATCH(B7,Sheet1!A:A,0))={" ASA","GIG"}),"NO",IF('Data
Entry'!B33="ASA12346","YES","YES"))

Biff

"dbl" wrote in message
...
Hi I am using the following formula in sheet Data Entry cell B14
=IF(INDEX(Sheet1!C:C,MATCH(B7,Sheet1!A:A,0),1)="AS A","NO","YES")
which works fine. But I need to add more to it as follows:

If the above also ="GIG", "NO","YES"
Plus if cell B33="ASA123456","YES","YES"

Cell B14 & B33 are on a sheet called Data Entry all the other info
comes from Sheet1

How do I add the above into my formula?

Bob