Cidrmatch between two lookups

[Stefanie]

I have two lookup files.

My first lookup file has the columns: ip, host, dnsName. We will call it List1.csv

The second lookup file has the columns: subnet, site, location. (with the subnets having CIDR notation). We will call this one List2.csv

I am trying to match up the items in List1 with their respective subnet from List2. However my search does not return any results.

If someone could assist me with my search, i'd appreciate it!

|inputlookup List1.csv |lookup List2.csv subnet output subnet site |where cidrmatch(subnet, ip) |table ip subnet dnsName

[SinghK]

You need a common field for that between 2 lookups

[Stefanie]

Thanks so if I rename the column in List2 from Subnet to ip, how would I word that in my search?