Formula help

I have a spreadsheet that contains thousands of addresses under these coulumn headings :

address number

Pre-directional

Street Name

Suffix

 

I have pasted in the same setup 20 columns over of addresses from another spreadsheet but also includes a heading for district name. I need a function to return the the district name if the address is an exact match.

 

Please help

By: Deanna

Leave a Reply

Your email address will not be published. Required fields are marked *