Hi Howard,
Thanks! I tried your email but it got sent back. Is there another one I can
try?

Tiffany

"L. Howard Kittle" wrote:

Hi Tiffany,

It's just a matter of geting it set up. I made two set ups using Peo's
suggestion and incorporated some of his suggestions into my solution.

If you want, send me an example workbook and I will take a look at it.


Regards,
Howard


"Tiffany" wrote in message
...
Hi, I have a retail price in column A, a list of the States in the U.S. in
column B and the sales tax C. I have a drop-down for the States which
matches
up with the tax. I want this value of the tax for the state to go into
cell
B2 and multiply it by the retail value. It looks like this:

A B C
1 Retail State Tax Tax Rate
2 $100 (cell to put tax rate * retail)
3 COLUMN 1 with drop down selection
4 States listed Correlating tax
rates
listed

Please help, I've been trying to do the Vlookup or Index and match and I'm
not getting it. Thanks!!!