Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting result of Index function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
clock | Excel Worksheet Functions | |||
Naming column in Index Function | Excel Worksheet Functions | |||
Variable values in Index function | Excel Worksheet Functions |