Excel 2010: Macro that does a NSLOOKUP
Posted on 2012-08-17
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).
1. Server: server123.abccompany.net
2. Address: xxx.xx.xxx.xx
4. Name: usercomputername.abccompany.net <--- (Just need it to return this value)
Would it be possible to just pull the 4th line and populate that data into column B, starting with Row 2?