Using Index info to cross reference CSV and Map

[IrishGuru]

Hello, I have an indexed list of internal IPs that I have been able to get a count for based on a CIDR list on a CSV Lookup table:

sourcetype="rapid7:insightvm:asset" "tags{}.name"="*" index=rapid7 | dedup id | fields ip
| lookup GracoSubnet2.csv CIDR_range as ip OUTPUT CIDR_range as CIDR Latitude Longitude
| where CIDR != "NONE"
| stats count, values(ip), as Unique_IP by CIDR

This gives me a great table with a count based on how many Unique internal IPs fall under one CIDR range. 

I have been unable to figure out how to take that count and reference the Lat and Lon data for those CIDRs that are in the CSV Lookup table. 

Any Ideas?