How do i get the sales tax to pop up???

Closed
Report
Posts
2
Registration date
Monday March 21, 2016
Status
Member
Last seen
March 22, 2016
-
Posts
10
Registration date
Tuesday March 22, 2016
Status
Member
Last seen
March 31, 2016
-
Hello, how do I make it so I cant type in a city and have it so the sales tax automatically inserts itself in? Thank you



1 reply

Posts
10
Registration date
Tuesday March 22, 2016
Status
Member
Last seen
March 31, 2016

It would depend on exactly what you want.

Here is what I would do so that you have all of the information visible

Create another sheet that lists all of the cities and their specific tax rate.

Go back to sheet1, and insert a column beside your city and apply a Vlookup to search on sheet2, and then show the specific tax rate to be applied. then, where ever you need your final total to be, apply a formula using that specific tax rate.
0