Spreadsheet: 85010d1285084304-index-several-named-tables-to-return-a-specific-value-in-the-table-reverse-lookup-index
Sheet: Survey

VLAN INFORMATION Enter Values to update all other spreadsheets |  |  |  | Reverse Lookup Table
VLAN Dropdown | VLAN Data |  |  | Client Name | Cable Number
PUBLIC VLAN | 30 |  | [NAME] to find client name  --> | Server01 | pub-00001 | <--- Type in a cable number from LIST_PUBLIC_CBL - this works
LIST_VLAN_LIST | LIST_VLAN_VALUES |  | [NAME] to find client name  --> | No Match Found! | pub-00001 | <--- Type in a cable number from Clients_cable_table - this does not work
- Select - | - |  | [NAME] to find client name  --> | Enter Cable #   --> |  | <--- Type in a cable number
PUBLIC VLAN | 30 |  | [NAME] to find client name  --> | Enter Cable #   --> |  | <--- Type in a cable number
ZONE 3 VLAN | 50 |  | [NAME] to find client name  --> | Enter Cable #   --> |  | <--- Type in a cable number
ZONE 4 VLAN | 60 |  | [NAME] to find client name  --> | Enter Cable #   --> |  | <--- Type in a cable number
ZONE 5 VLAN | 100 |  | [NAME] to find client name  --> | Enter Cable #   --> |  | <--- Type in a cable number
ZONE 6 VLAN | 110 |  | [NAME] to find client name  --> | Enter Cable #   --> |  | <--- Type in a cable number
END VLAN Template! | END VLAN Template! |  | [NAME] to find client name  --> | Enter Cable #   --> |  | <--- Type in a cable number
PUBLIC-VLAN Client Dropdown | Public - Cable Number | Zone 3 Client Dropdown | Zone 3 - Cable Number | Zone 4 Client Dropdown | Zone 4 - Cable Number
Server02 | PUB-00002 | [NAME] | Z3-00002 | CORP-PC03 | CORP-00003 | <--- This row shows the VLOOKUPS work with the selection
Clients_Cable_Table |  |  |  |  |  | <--- This row has the name of the table that references a:24 through f:32
publictable |  | zone3table |  | zone4table |  | -<--- This Row has the name of the Zone Tables
PUBLICVLAN | LIST_PUBLIC_CBL | ZONE3VLAN | LIST_ZONE3_Cbl | ZONE4VLAN | [NAME] | <--- This Row has the name of the tables
- Select - | - | - Select - | - | - Select - | - | This Box Represents the boundaries of the client and cable lists
--Core Servers-- | - Core Servers | [NAME] | - | --Corporate PCs-- | -
Server01 | PUB-00001 | Z3Client01 | Z3-00001 | CORP-PC01 | CORP-00001
Server02 | PUB-00002 | [NAME] | Z3-00002 | CORP-PC02 | CORP-00002
Server03 | PUB-00003 | Z3Client03 | Z3-00003 | CORP-PC03 | CORP-00003
- No Connection - | - | - No Connection - | - | - No Connection - | -
END Client Template! |  | END Client Template! |  | END Client Template!
9 | publictable | 9 | zone3table | 9 | zone4table | <--- This row has the names of the tables that are referenced by the ZONE_Table table
PUBLIC-VLAN Client Dropdown | Public - Cable Number
 |  |  |  |  |  | <--- This row shows the VLOOKUPS work with the selection
zone5-01 | Z5-00001 | zone6-01 | Z6-00001 |  |  | <--- This row has the name of the table that references a:21 through f:30
Clients_Cable_Table2 |  |  |  |  |  | -<--- This Row has the name of the Zone Tables
Zone5Table |  | Zone6Table |  |  |  | <--- This Row has the name of the tables
ZONE5VLAN | LIST_ZONE5_CBL | ZONE6VLAN | LIST_ZONE6_CBL |  |  | This Box Represents the boundaries of the client and cable lists
- Select - | - | - Select - | - | - Select - | -
--Core Servers-- | - Core Servers | --Core Servers-- | - Core Servers
zone5-01 | Z5-00001 | zone6-01 | Z6-00001
zone5-02 | Z5-00002 | zone6-02 | Z6-00002
zone5-03 | Z5-00003 | zone6-03 | Z6-00003
zone5-04 | Z5-00004 | - No Connection - | - | - No Connection - | -
zone5-05 | Z5-00005
zone5-06 | Z5-00006 | 9 | Zone6Table |  | FakeOut
zone5-07 | Z5-00007
zone5-08 | Z5-00008
- No Connection - | -
END Client Template! |  |  |  |  |  | <--- This row has the names of the tables that are referenced by the ZONE_Table table
14 | Zone5Table
CableTable |  | Is the table below necessary? Same info exists in LIST_VLAN_LIST along with "- Select -"
LIST_Client_List | LIST_Cable_List | VLAN_Table1 | ZONE_Table
PUBLICVLAN | LIST_PUBLIC_CBL | PUBLIC VLAN | publictable
ZONE3VLAN | LIST_ZONE3_Cbl | ZONE 3 VLAN | zone3table
ZONE4VLAN | [NAME] | ZONE 4 VLAN | zone4table
ZONE5VLAN | LIST_ZONE5_Cbl | ZONE 5 VLAN | Zone5Table | <--- I added another Clients_Cable_Table2 here to select the next set of Tables - if the table isn't exatly 9 rows long, it will return an improper value
ZONE6VLAN | LIST_ZONE6_Cbl | ZONE 6 VLAN | Zone6Table | <--- I added another Clients_Cable_Table2 here to select the next set of Tables
Select Vlan | Select Client | Cable Number Shows up here
ZONE 3 VLAN | [NAME] | Z3-00002 | <--- Modified by [NAME] works, but cells are manually entered based on ranges
ZONE 3 VLAN | [NAME] | Z3-00002 | <--- Modified by [NAME] works, but cells are manually entered based on ranges (Fixed to add $ to ensure the table doesn't move)
ZONE 3 VLAN | Z3Client01 | Z3-00001 | <--- Modified by [NAME] works, but cells are manually entered based on ranges (Fixed to add $ to ensure the table doesn't move)
ZONE 3 VLAN | [NAME] | Z3-00002 | <--- Modified by [NAME] works, but cells are manually entered based on ranges (Fixed to add $ to ensure the table doesn't move)
ZONE 3 VLAN | [NAME] | Z3-00002 | <--- Modified by [NAME] works, but cells are manually entered based on ranges (Fixed to add $ to ensure the table doesn't move)
PUBLIC VLAN | Server01 | PUB-00001 | <--- Modified to use nammed ranges with VLAN_Table1 as a reference
ZONE 3 VLAN | [NAME] | Z3-00002 | <--- Modified to use nammed ranges with VLAN_Table1 as a reference
ZONE 3 VLAN | [NAME] | Z3-00002 | <--- Modified to use nammed ranges with VLAN_Table1 as a reference
ZONE 6 VLAN | zone6-03 | Z6-00003 | <--- Modified to use nammed ranges with VLAN_Table1 as a reference