Good Day,
I am having a bit of trouble finding a solution to this one and I think that my main problem is that I don't know exactly what to search for. I’m sure that this question has been answered previously but I can’t see to find it after searching.
My issue is this:
I have a spreadsheet with servers and those are in Column E. In Column H I have the same Servers in a different order and in Column I I have the SubnetMasks of those Servers.
I’m trying to set it up so that Column F will match the server referenced in Columns H and I.
So for example
Column E Column F Column H Column I
Server 1 Server 2 Subnet B
Server 2 Server 3 Subnet A
Server 3 Server 1 Subnet C
I’m trying to match it up so that Column F has the Subnet for the respective servers in Column E by referencing what the subnet for that server is.
My goal:
Column E Column F Column H Column I
Server 1 Subnet C Server 2 Subnet B
Server 2 Subnet B Server 3 Subnet A
Server 3 Subnet A Server 1 Subnet C
I am having a bit of trouble finding a solution to this one and I think that my main problem is that I don't know exactly what to search for. I’m sure that this question has been answered previously but I can’t see to find it after searching.
My issue is this:
I have a spreadsheet with servers and those are in Column E. In Column H I have the same Servers in a different order and in Column I I have the SubnetMasks of those Servers.
I’m trying to set it up so that Column F will match the server referenced in Columns H and I.
So for example
Column E Column F Column H Column I
Server 1 Server 2 Subnet B
Server 2 Server 3 Subnet A
Server 3 Server 1 Subnet C
I’m trying to match it up so that Column F has the Subnet for the respective servers in Column E by referencing what the subnet for that server is.
My goal:
Column E Column F Column H Column I
Server 1 Subnet C Server 2 Subnet B
Server 2 Subnet B Server 3 Subnet A
Server 3 Subnet A Server 1 Subnet C