If function using Index
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
|