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 device...