buschman007
New Member
- Joined
- May 30, 2018
- Messages
- 6
So I have a list of network addresses (IPv4). I need to add a label for these subnets.
My legend will look like this:
10.0.0.0 = Corp Data VLAN
10.1.0.0 = Corp Voice VLAN
10.0.10.0 = VPN VLAN
10.3.0.0 = Baltimore Branch Data VLAN
10.3.1.0 = Baltimore Branch Voice VLAN
10.4.0.0 = DC Branch Data VLAN
10.4.1.0 = DC Branch Voice VLAN
etc.
So I have a list of Network Addresses currently. I need a formula that allows me to populate the "Network Name" column with the legend above. How can I best accomplish this? I'm not finding formula that allow me to do one offs, but not a list like the legend above. let me know if anyone can help.
Thanks,
Mike
<tbody>
</tbody>
My legend will look like this:
10.0.0.0 = Corp Data VLAN
10.1.0.0 = Corp Voice VLAN
10.0.10.0 = VPN VLAN
10.3.0.0 = Baltimore Branch Data VLAN
10.3.1.0 = Baltimore Branch Voice VLAN
10.4.0.0 = DC Branch Data VLAN
10.4.1.0 = DC Branch Voice VLAN
etc.
So I have a list of Network Addresses currently. I need a formula that allows me to populate the "Network Name" column with the legend above. How can I best accomplish this? I'm not finding formula that allow me to do one offs, but not a list like the legend above. let me know if anyone can help.
Thanks,
Mike
Network Address | Network Name |
10.0.0.0 | Corp Data VLAN |
10.0.0.0 | Corp Data VLAN |
10.0.0.0 | Corp Data VLAN |
10.1.0.0 | Corp Voice VLAN |
10.0.10.0 | VPN VLAN |
10.0.10.0 | VPN VLAN |
10.0.10.0 | VPN VLAN |
10.3.0.0 | Baltimore Branch Data VLAN |
10.3.0.0 | Baltimore Branch Data VLAN |
10.3.0.0 | Baltimore Branch Data VLAN |
10.3.0.0 | Baltimore Branch Data VLAN |
10.3.0.0 | Baltimore Branch Data VLAN |
10.3.0.0 | Baltimore Branch Data VLAN |
<tbody>
</tbody>