stuart.munn@angus-it.com
New Member
- Joined
- Mar 24, 2002
- Messages
- 4
I am trying to use excel to pull back a hostname using its IP address, yes I know DNS should do this, but our DNS admin people are not very efficient! I have a column of IP addresses and a 2nd column of their equivalent names, when I try to use VLOOKUP to pull back the hostname using the IP address I just get the #N/A error. Is this because excel can't sort IP addresses properly? I've tried formatting the cells as text but that doesn't help. Any info greatly appreciated.