archwayguy
Technical User
I have a very large spreadsheet full of network data. I need to cross-reference source A with source B. Basically, I have a physical location in Column A, then an IP address in Column B and C. I need B & C to match and for those ip addresses to stay within their matching locations with Column A. I'm looking at conditional formatting, but I have no idea how to do this or where to begin, and the formulas I've found either don't apply or I can't figure out. Someone please help.
Spreadsheet looks something like this:
A B C
Site IP1 IP2
New York 192.168.1.1 192.168.1.4
New York 192.168.1.3 192.168.1.1
I need the values in B & C to pair up on their duplicates, and for them to stay in their respective sites and not roam around in the sheet and get out of order. That's very important.
Spreadsheet looks something like this:
A B C
Site IP1 IP2
New York 192.168.1.1 192.168.1.4
New York 192.168.1.3 192.168.1.1
I need the values in B & C to pair up on their duplicates, and for them to stay in their respective sites and not roam around in the sheet and get out of order. That's very important.