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