I was wondering how to find a partial value in a string that contains both text and numbers.

I came across a similar problem in the past and I believe I used ISNUMBER(FIND to find the value. However, this contains both numbers and text as opposed to just a number.

I want to find a value within a Pivot Table and put the result in a seperate table.

The exact values I want are under the column 'Path' and want to find any value that contains either: 'Phase 1', 'Phase 2', 'Phase 3', 'Phase 4', 'Phase 5' as well as: 'Active', 'Proposed' and '1 - Critical'.

I will attach an example of the Pivot Table below.

```
| Severity | Path | State |
|--------------|--------------------------|----------|
| 1 - Critical | \Release 1\Phase 3\Test\ | Active |
| 2 - High | \Release 1\Phase 2\ | Proposed |
| 3 - Medium | \Release 1\Phase 6.3\ | Resolved |
```

I believe this is the formula to search for a numerical value:

```
=SUMPRODUCT((Pivot_Data[State]={"Active","Proposed"})*(ISNUMBER(FIND("2",Pivot_Data[Severity])))
```