Tere are two ways to accomplish this.

## Option 1 (clunky and less sophisticated, but perhaps easier to follow)

Because the `MATCH`

function returns `#N/A`

(or an error) when it can't find the match against a specific sheet, one solution is to wrap `ISNA`

statements into your nested `IF`

statements.

I have given you an example for the first 3 sheets here:

```
=IF(ISNA(MATCH(A2,'6(AKK)'!$A$1:$A$100,0)),IF(ISNA(MATCH(A2,'6(K3)'!$A$1:$A$100,0)),IF(ISNA(MATCH(A1,'6(KESLING)'!$A$1:$A$100)),"[See Note]","Kesehatan Lingkungan"),"K3"),"AKK")
```

**Note** - keep embedding the `IF(ISNA(MATCH ...`

statements here. On the last one, place "Gagal" in this spot.

As you can see, it will get pretty long and ugly. Yet it will work.

Lastly, enter this a **regular** formula, not an array formula.

## Option 2 (more sophisticated and efficient, requires a little more initial input)

- Define a Named Range as sList with the formula
`=MID(TRANSPOSE(GET.WORKBOOK(1))&T(NOW()),FIND("]",TRANSPOSE(GET.WORKBOOK(1))&T(NOW()))+1,255)`

(see more about GET.WORKBOOK)
- Set up a reference table that has the sheet names with the corresponding return values and Define this Range with a name of return_values

- Enter this formula (as an array) into cell B1
`=VLOOKUP(INDEX(sList,MATCH(TRUE,COUNTIF(INDIRECT("'"&sList&"'!$A$1:$A$100"),A1)>0)),return_value,2,0)`

and drag down the rows for each value in column A