Tax Rates

[Guest]

I have an order form that contains two columns of tax rate information in a
hidden portion of the worksheet. Column "A" list 52 counties by name.
Column "B" list each counties tax rate. In the printed form there is a
control form drop down list that allows selection of each county. When a
county is selected in this drop down I need the sales tax rate for that
county to display in a different cell to calculate the tax rate. Any ideas?

 

[Bob Phillips]

What sort of dropdown? If it is a forms toolbar dropdown, link it to a cell,
right-click the dropdown, select Format>Control>control and set the Cell
link. Then lookup using that cell

=VLOOKUP(cell_link,A:B,2,FALSE)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

I have an order form that contains two columns of tax rate information in a
hidden portion of the worksheet. Column "A" list 52 counties by name.
Column "B" list each counties tax rate. In the printed form there is a
control form drop down list that allows selection of each county. When a
county is selected in this drop down I need the sales tax rate for that
county to display in a different cell to calculate the tax rate. Any

ideas?

 

[Gord Dibben]

In the cell to receive the Tax Rate enter this formula.

=VLOOKUP(cellref,$A$1:$B$52,2,FALSE)

Cellref is the cell with the drop-down selection.


Gord Dibben MS Excel MVP