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?

What sort of dropdown? If it is a forms toolbar dropdown, link it to a cell,
right-click the dropdown, select FormatControlcontrol 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)

"Greyson" wrote in message
...
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?

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

On Wed, 8 Nov 2006 14:57:01 -0800, Greyson
wrote:

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?