Forum Discussion
Assigning Source IP to Client excel function
Hello, I am trying to figure out a function that allows me to assign a device to an IP address. The issue is I have 20,000 lines of data and many many IP addresses.
I can create as many devices as I please like "laptop 1" "desktop 3" "server 9" and assign a particular IP address to them. Is there a simpler way to do this, instead of manually figuring out all the IP addresses and keeping a track of what IP address is assigned to what device.
8 Replies
- NikolinoDEPlatinum Contributor
Here is an upside-down solution from (5/15/05) Rob Bovey, Created.
I found it on the internet a long time ago. Maybe it will help you.
I would be happy to know if I could help.
I wish you continued success with your Computer
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
- morai1104Copper Contributorno sure how this will help. All I see is a get IP address button.
- SchnittlauchIron ContributorDoes "Vlookup" help you?
- SchnittlauchIron ContributorJust for information, do you have also over hundreds of devices or is the number of devices limited? Do you think possible to list all devices to list the devices next to the columns?
Or are you searching for any kind of nslookup integration?
Best regards
Schnittlauch- morai1104Copper ContributorSo there's a strong possibility that there are over 100 different Ip addresses but the good news is I can create as many devices as I want (100s even 1000s). Assigning devices makes it easier to run an analysis because people remember texts better than numbers.
How can i run the nslookup function in this situation?