hello,
I have a unique list of City and States as follows
Col A Col B
City State
Boston MA
Quincy MA

Albany NY
Buffalo NY

I want to perform this scenario: Col A is a drop down box with all the
Cities. When user selects from the drop down City Boston, MA fills out in col
B. If the user selects Albany, NY fills out the next cell on the right of
city in col B. It will make it easier for the users, because right now therer
are a lot of wrong mapping from the users end.
Your help is very much appreceated as always. All the posts have been very
helpful to me.
Thank you
Bob



--
Bob

maybe something like this may help

http://www.contextures.on.ca/xlDataVal02.html

--


Gary


"Bob" wrote in message
...
hello,
I have a unique list of City and States as follows
Col A Col B
City State
Boston MA
Quincy MA

Albany NY
Buffalo NY

I want to perform this scenario: Col A is a drop down box with all the
Cities. When user selects from the drop down City Boston, MA fills out in
col
B. If the user selects Albany, NY fills out the next cell on the right of
city in col B. It will make it easier for the users, because right now
therer
are a lot of wrong mapping from the users end.
Your help is very much appreceated as always. All the posts have been very
helpful to me.
Thank you
Bob



--
Bob

in the adjacent cell where you want the state

=if(cell with dropdown = "","",vlookup(cell with dropdown,A:B,2,False))

so if the cell with the dropdown is in J2, then in K2

=if(J2= "","",vlookup(J2,A:B,2,False))

I could see problems with, for example Kansas City (Missouri or Kansas?)

--
Regards,
Tom Ogilvy


"Bob" wrote in message
...
hello,
I have a unique list of City and States as follows
Col A Col B
City State
Boston MA
Quincy MA

Albany NY
Buffalo NY

I want to perform this scenario: Col A is a drop down box with all the
Cities. When user selects from the drop down City Boston, MA fills out in
col
B. If the user selects Albany, NY fills out the next cell on the right of
city in col B. It will make it easier for the users, because right now
therer
are a lot of wrong mapping from the users end.
Your help is very much appreceated as always. All the posts have been
very
helpful to me.
Thank you
Bob



--
Bob