Vlookup from a dropdown box

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

Option B…control from the form toolbar.

Reply | Quote

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)

Reply | Quote

THANKS!

Reply | Quote