Changing a Number to a Name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with a report that provides a list of several IP addresses for
employees accessing my training site. I have a list of the names that match
each IP address. I would like to be able to run a report/macro where the IP
addresses change to an actual name for data analysis. Is there a way in
Excel 2000 to perform this type of function? Thanks for any help you can
provide.

Rich
 
Assuming you IP adresses are in Column A100 and names in Column B100 then
Vlookup will return a name from an IP address thus:

=vlookup(cell address of IP address you are looking for,a1:b100,2,false)

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Static IP on a printer fails 6
Excel Barcoding using a central database repositories 0
sorting customer name and IP with value 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Unable To Connect To Internet - IP Address Conflict 6
How can I replace text with a specific number? 3
vlookup 1
how to compare two sheets with repeating rows 1

Back
Top