mapping scanner name to IP address

[rmadk]

Hi All,

I need some help in getting one task completed, i have two file where thousands of IP address are there and in other file i have some scanner names and subnet mask and scanner IP address i need to locate scanner name to particular IP address .




IP address

Qip_primaryip Hostname
192.168.4.11 csrstaser1220



Scanner Names

Scanner Subnet Assetgroup Scanner_ip
csn1002rmsn 192.168.0.1/24 VSAC_scan_csn1002rmsn 192.168.0.23
csn1002rmsn 192.160.0.0/11 VSAC_scan_csn1002rmsn 192.160.0.23
csn3002dmsn 192.0.0.0/8 VSAC_scan_csn3002dmsn 192.0.0.23

[arlu1201]

Hello rmadk,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

[rmadk]

Hi All,

I have two files with data as IP address, Scanner name , Host Name, etc. i need to pickup Ip address from one file and look for same in other if the same ip available then copy the line of data present in it and pest in output file

i cannot upload the file.