List Value

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

Guest

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
 
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?)
 
Back
Top