Replace Row Of First Cells Match

replace row of first cells match

replace row if 1st column match

But that's only a very small part of my question.

1. I have an original list of IP addresses which contain many duplicates.
2. I used "The Duplicate Finder" Add-in and created a unique list of IP addresses from the original list.
3. I did proprietary search on the unique IP list to get an approximate geographic location of each IP address.

Now I want to match all the IP search information to all the duplicates in the original list.

It's difficult for me to craft an exact question without knowing the proper terminology, so I'll "illustrate" a few point below.

Original List of IP addresses in a single column (IP Address)

IP address
12.34.56.78
12.34.56.78
98.76.54.32
95.62.84.37
95.62.84.37
95.62.84.37
95.62.84.37
55.11.99.225
55.11.99.225
23.56.89.14
78.56.12.43
78.56.12.43

Unique list of IP address with additional info in 3 more columns (4 columns total)

IP Address Country State City
12.34.56.78 USA CA SomeName
98.76.54.32 USA NY AnotherName
95.62.84.37 GB England Ye OldeName
55.11.99.225 MX EL SmokyCity
23.56.89.14 USA WA RainyCity
78.56.12.43 USA FL ViceCity

What I want to do is if an IP address in the original list matches the IP address in the unique list, the original IP row is replaced with the matching IP row in the unique list.