Populate DNS IP details

Question

Dear Experts,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; I want to prepare a report as below , with&nbsp; 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?&nbsp;Br,Anupam&nbsp;

nikolinode · Answer

anupambit1797&nbsp;&nbsp;IP2LocationMaybe it will help you :).

anupambit1797 · Answer

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

peiyezhu · Answer

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

anupambit1797 · Answer

Yes , like whose IP address these were.

Forum Discussion

Populate DNS IP details

4 Replies

Resources