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?