Routing Slips

[Marcus]

I am trying to set up a routing that that will give the user of the template
an option as to who they want to send it to based on what area they live in.
So my question is, can you set up a routing slip that will pop up an option
as to who to send it to?

 

[Mike Campbell]

In Column B input your cities. In Column C input your Contacts. Use Cell A1
for user input cell. In Cell A2 enter the following formula:
=VLOOKUP(A1,B1:C20,2)

 

[Marcus]

How does that help a routing slip?

In Column B input your cities. In Column C input your Contacts. Use Cell A1
for user input cell. In Cell A2 enter the following formula:
=VLOOKUP(A1,B1:C20,2)