Here's how to do this with your data laid out exactly as you have it now. This formula goes in `C2`

on your Sheet1:

```
=IF(ISNA(MATCH(B2,Sheet2!$A$1:$A$40,0)),IF(ISNA(MATCH(B2,Sheet2!$B$1:$B$40,0)),IF(ISNA(MATCH(B2,Sheet2!$C$1:$C$40,0)),IF(ISNA(MATCH(B2,Sheet2!$D$1:$D$40,0)),"Not Found","Pacific"),"Mountain"),"Central"),"Eastern")
```

It's ugly but it works. You may need to adjust the four absolute references to Sheet2 (e.g. `Sheet2!$A$1:$A$40`

) if your data on that sheet goes past row 40.

The final formula consists of four uses of the MATCH function, each searching only one column of area codes.

Here's how I built the formula.

I used the MATCH function. MATCH can only search a single column for a value. First I created four separate MATCH formulas. Each searches only one of the timezone columns. For example, to search the "Eastern" column for the value (area code) found in cell `B2`

:

```
=MATCH(B2,Sheet2!$A$1:$A$40,0)
```

Supposing `B2`

contains **201**, this returns `2`

because 201 is the 2nd item in the column. But if `B2`

contains **205** this returns `#N/A`

. We catch this by wrapping the formula with the ISNA formula:

```
=IF(ISNA(MATCH(B2,Sheet2!$A$1:$A$40,0)),"no_next_formula","Eastern")
```

ISNA tests whether the MATCH formula returns `#N/A`

. If yes/true, it returns "no_next_formula". If no/false it returns "Eastern" because MATCH found our area code in the Eastern area code column.

We can create four of these formulas, changing the range referenced on Sheet2 appropriately to search the other three area codes. An example worksheet might look like this:

Now, to combine these into the single formula shown above, I copied the entire formula in my column F (less the `=`

sign) and replaced the text `"no_next_formula"`

in column E's formula.

Formula in F2:

```
=IF(ISNA(MATCH(B2,Sheet2!$D$1:$D$40,0)),"Not Found","Pacific")
```

Formula in E2 (before):

```
=IF(ISNA(MATCH(B2,Sheet2!$C$1:$C$40,0)),"no_next_formula","Mountain")
```

Formula in E2 (after inserting formula from F2):

```
=IF(ISNA(MATCH(B2,Sheet2!$C$1:$C$40,0)),IF(ISNA(MATCH(B2,Sheet2!$D$1:$D$40,0)),"Not Found","Pacific"),"Mountain")
```

I then repeated these steps, copying the formula now in `E2`

to replace the text `"no_next_formula"`

in `D2`

's formula. Once this is done for the formula in `C2`

we have the complete formula shown above.