Maybe it's because you haven't set it up correctly, you need to create a
table first with all the states and their respective sales taxes

AL whatever%
and so on

then in the dropdown you select a state and it pulls up the tax, is that
what you are trying to do?
Also in what cell is the dropdown (validation?)

If you have a 2 column table called MyTable and the dropdown is in C2, then

=IF(C2="","",VLOOKUP(C2,MyTable,2,0))

then whatever result is returned will be used to do the calculation so in B2
you can use

=IF(C2="",0,VLOOKUP(C2,MyTable,2,0))*price





--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"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!!!