Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a table and I want the user to select the state from a dropdown. When she picks from the dropdown the appropriate state, I want the current tax rate to populate in another column so I can perform a calculation.

    So, I have the list of states in column a, the rates in column b.
    I have my dropdown box and the states appear and I can select one.
    Now..I need to know where to put the Vlookup command to extract the rate.

    Thanks.
    Deb

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    What kind of dropdown are you using?

    a. Data | Validation with the List option
    b. A combo box from the Forms toolbar
    c. A combo box from the Control Toolbox toolbar

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Option B...control from the form toolbar.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You have to specify the cell link in the properties of the combo box. This cell will contain the index of the item selected by the user. For example if the user selects the 5th item from the list, the cell link will contain 5. You can use this with the INDEX function. Let's say that the states are in A2:A51, the tax rates in B2:B51, and the cell link is D2.
    The following formula will return the tax rate for the selected state:

    =INDEX(B2:B51,D2)

  5. #5
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts


    THANKS!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •