States Codes

  • Thread starter Thread starter Fernando Duran
  • Start date Start date
F

Fernando Duran

Hi, I want to add to a program a pull down menu, like a combobox, but
with the abreviations of States, and the State. When the user makes
his selection, the only thing that'll print, will be only the State
code, like a validation... but I don't know, how to show the Code and
the State, or the State and print only the code in the spreadsheet.
I need help...
 
how about setting up a list on a seperate sheet, and using a vlooku
-fx- next to a cell w/ data validation -> list.

maybe i'm not understanding though.

eg. if your list of abbreviations is on sheet 2, column A, and th
cooresponding full names are in column B (A1:B50 - US i'm assuming)
then where ever your drop down box is, put in this formula:

=vlookup(DropDownBox,Sheet2!A1:B50,2,FALSE)

if i've botched this, i'm sorry.

-zac
 
Back
Top