Verify Address
Previous  Top  Next

To verify address information, select the worksheet cell where the returned data will begin. In this case it will be in column F, just to the right of the address list. Click on "Verify Address", the second icon from the right on the CDXStreamer toolbar:


Input the cell locations of the first address components, in row 2. (Alternatively, for an address contained in a single cell, specify "single-line address" in the dialog and input its cell location.) Select the desired data field to be returned, and click OK:


Here you can also specify additional options:

Autocopy: Will return data for all addresses listed contiguously in a column

Set Array to Values: The custom functions returned will automatically be converted to values (please see the Help section Custom Functions for more information.)

For these addresses, the +4 portion of the ZIP Code was returned to column F:


For a single data point, you can also input address data directly. For example, a single line address would be input like this: