itsmevic
asked on
Excel 2010: Macro that does a NSLOOKUP
Hello Experts!
Somewhat of an unusual request for a macro here and I'm not sure if it's doable or not. What I'd like to accomplish is to have the macro to look at the IP address in Column A, Starting with Row 2 amd automatically populate Column B, Row 2 of my spreadsheet with the NSLOOKUP computername value. The typical NSLOOKUP return looks something like this (usually returns 4 lines) (See example below).
c:\>nslookup xxx.xx.xxx.xxx
1. Server: server123.abccompany.net
2. Address: xxx.xx.xxx.xx
3.
4. Name: usercomputername.abccompan y.net <--- (Just need it to return this value)
Address: xxx.xx.xxxx.xxx
Would it be possible to just pull the 4th line and populate that data into column B, starting with Row 2?
Somewhat of an unusual request for a macro here and I'm not sure if it's doable or not. What I'd like to accomplish is to have the macro to look at the IP address in Column A, Starting with Row 2 amd automatically populate Column B, Row 2 of my spreadsheet with the NSLOOKUP computername value. The typical NSLOOKUP return looks something like this (usually returns 4 lines) (See example below).
c:\>nslookup xxx.xx.xxx.xxx
1. Server: server123.abccompany.net
2. Address: xxx.xx.xxx.xx
3.
4. Name: usercomputername.abccompan
Address: xxx.xx.xxxx.xxx
Would it be possible to just pull the 4th line and populate that data into column B, starting with Row 2?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER