How do i get the tax rate to pop up by itself???

Closed
mgamble1990 Posts 2 Registration date Monday March 21, 2016 Status Member Last seen March 22, 2016 - Mar 21, 2016 at 01:37 PM
So I am trying to make an invoice for the company I work for.
my question is:
How do I make it so I type a city in the city cell and then automatically the sales tax rate would pop up in the tax cell in the bottom?
I don't want it to add up the sales tax but I want it to be able to put either 7% or 8% in automatically so we don't have to look it up and it gets calculated correctly.