Have found solutions when it is known what row a value is one but what I am looking for is searching 4+ columns in a table to determine the header of the column in which the value resides. Example(s): 9 = "Guest Circuit ID", 7 = "Primary Circuit ID", 2 = "Backup Circuit ID"
Ultimately this would be best if tied into results in a pivot table so assigning a value using Name Manager might next practical step once it is determined how to find value. I thought an index/match would solve this issue but have been unable to make work. Cells will be alphanumeric as well and may include symbols.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Ultimately this would be best if tied into results in a pivot table so assigning a value using Name Manager might next practical step once it is determined how to find value. I thought an index/match would solve this issue but have been unable to make work. Cells will be alphanumeric as well and may include symbols.
Primary Circuit ID | Backup Circuit ID | Guest Circuit ID | Primary Router Name |
1 | 2 | 3 | 4 |
7 | 8 | 9 | 10 |
13 | 14 | 15 | 16 |
19 | 20 | 21 | 22 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>