https://community.splunk.com/t5/Splunk-Search/Cidrmatch-between-two-lookups/m-p/584006#M203374 <P>I have two lookup files.</P><P>My first lookup file has the columns: ip, host, dnsName. We will call it List1.csv</P><P>The second lookup file has the columns: subnet, site, location. (with the subnets having CIDR notation). We will call this one List2.csv</P><P>&nbsp;</P><P>I am trying to match up the items in List1 with their respective subnet from List2. However my search does not return any results.</P><P>&nbsp;</P><P>If someone could assist me with my search, i'd appreciate it!</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">|inputlookup List1.csv |lookup List2.csv subnet output subnet site |where cidrmatch(subnet, ip) |table ip subnet dnsName</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 07 Feb 2022 19:15:27 GMT Stefanie 2022-02-07T19:15:27Z https://community.splunk.com/t5/Splunk-Search/Cidrmatch-between-two-lookups/m-p/584006#M203374 <P>I have two lookup files.</P><P>My first lookup file has the columns: ip, host, dnsName. We will call it List1.csv</P><P>The second lookup file has the columns: subnet, site, location. (with the subnets having CIDR notation). We will call this one List2.csv</P><P>&nbsp;</P><P>I am trying to match up the items in List1 with their respective subnet from List2. However my search does not return any results.</P><P>&nbsp;</P><P>If someone could assist me with my search, i'd appreciate it!</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">|inputlookup List1.csv |lookup List2.csv subnet output subnet site |where cidrmatch(subnet, ip) |table ip subnet dnsName</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 07 Feb 2022 19:15:27 GMT https://community.splunk.com/t5/Splunk-Search/Cidrmatch-between-two-lookups/m-p/584006#M203374 Stefanie 2022-02-07T19:15:27Z https://community.splunk.com/t5/Splunk-Search/Cidrmatch-between-two-lookups/m-p/584011#M203377 <P>You need a common field for that between 2 lookups</P> Mon, 07 Feb 2022 19:36:28 GMT https://community.splunk.com/t5/Splunk-Search/Cidrmatch-between-two-lookups/m-p/584011#M203377 SinghK 2022-02-07T19:36:28Z https://community.splunk.com/t5/Splunk-Search/Cidrmatch-between-two-lookups/m-p/584017#M203379 <P>Thanks so if I rename the column in List2 from Subnet to ip, how would I word that in my search?</P> Mon, 07 Feb 2022 20:11:39 GMT https://community.splunk.com/t5/Splunk-Search/Cidrmatch-between-two-lookups/m-p/584017#M203379 Stefanie 2022-02-07T20:11:39Z