Populate DNS IP details

[anupambit1797]

Dear Experts,

                    I want to prepare a report as below , with  column "B" to be populated with the details on the IPs in Column "A", so I have to Google every time against each entry..

Is there a quick Formula/Query , we can run to populate them all at once?

Br,

Anupam

[#2]

@anupambit1797 

IP2Location

Maybe it will help you :).

[#3]

Thanks Nikolino, my bad, seems our IT desk blocked us to add any Excel addons from Web.. probably due to some security reasons..

Br,
Anupam

[#4]

populated with the details ?
what kind if details?
location?

[#5]

Yes , like whose IP address these were.