I have the ff. tables in a worksheet:
Table A (Sheet 1) - a list of 1000+ computers that don't have a specific piece of software installed
Table B (Sheet 2) - a list of 15000+ host-to-IP address entries from the local DNS obtained using the `Get-WmiObject` PS cmdlet.
We're in the process of investigating why the number of computers generated for Table A remain high, and I need to get their IP addresses from Table B. I was able get the corresponding IP addresses of the machines in Table A from their corresponding DNS entries in Table B by using the `VLOOKUP` function. The big hurdle that I have is for those hundreds of machines with two or more IP addresses recorded in DNS, as there many laptops that roam and get associated with different subnets. How would it be possible to concatenate the IP address values of two or more cells into one cell for each machine that has multiple IP addresses associated with it using a formula? Is there a way to make the formula intelligent enough to detect multiple-entry hostnames and perform the needed concatenation of their multiple IP addresses, and just get the single IP address values for those with just single-entry hostnames?
For example if a single computer has 3 entries (3 rows) in `Table B` that lists its name `PC1.abc.com` 3 times for its 3 IP addresses of `10.10.10.15`, `192.168.10.11`, and `172.16.25.23`, then that computer's entry (1 row) in `Table A` should have a value under the `IP Address` column which should be equal to the combination of all those 3 IP addresses, separated by commas (`,`) -- `10.10.10.15, 192.168.10.11, 172.16.25.23`. I was hoping to use purely non-macro-enabled Excel for this. Thanks
Bookmarks