Excel vlookup for lat/long points against ranges
Posted on 2010-11-29
I have 2 spreadsheets, one with a list of addresses with latitude longitude points, and the other is an index of neighborhoods with minimum and maximum values for longitude and latitude. (They're essentially best-fit bounding boxes for non-square neighborhoods, so they overlap a bit). I want to determine which neighborhood each of my addresses are in. Vlookup seems the way to do it, but I cant seem to figure it out.