Address query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a spreedsheet that will check street adresses entered
in an Excel spreadsheet against a master street index and then produce a new
result in a new column. As an example if Post Street is in the master strret
index then the result in the new column is Zone 4. If Birchwood Drive is in
the master street index then the result in the new coloum is Zone 3. Any
suggestions?

Thanks,
 
I would like to create a spreedsheet that will check street adresses entered
in an Excel spreadsheet against a master street index and then produce a new
result in a new column. As an example if Post Street is in the master strret
index then the result in the new column is Zone 4. If Birchwood Drive is in
the master street index then the result in the new coloum is Zone 3. Any
suggestions?

Thanks,
Click to expand...

Check out VLOOKUP in HELP


--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
Splitting up address 3
reversing text within cells 1
Split data in field on character return 0
excel formula 2
Word Create a Phone Book using MailMerge in word 2007 0
In search of a new Obelisk 6
Replacing a formula with the actual string or number 1

Back
Top