To do this simply enter the following formula beginning in the first row of your data which in this case is cell H3 referencing the first customer zip in G3.
=IF(@CDXDistance(G3,"07869")<=100,"YES","NO")
and then copy this down your list.
The formula returns "YES" or "NO" depending if the customer is within the specified radius. Should you wish you can also include fixed cell references (i.e. $A$1) for the central zip code and radius distance to make updating easier. This technique is also more forgiving than using VLookup when your customer data includes zip codes without leading zeroes or with Zip+4. It also works well with our Canadian database as well as with US data.
|