Adding multiply taxes to cell

[Treecko]

Hi Gang
Hope everyone is having a great day
Would someone please show me how to apply a provincial taxes in a drop box (I've done already "E9") but I would like to have the taxes formulate in the cell beside it "D9". I've inserted a sample sheet that I hope makes it clearer. I thank you in advance for your help
Regards

[ratcat]

G'day

This is one way

Please Login or Register  to view this content.

[Treecko]

Thanks for the quick reply. One (hopefully last) question. How can I "make D9" show the tax amount instead of the tax itself.
Thanks

[AlKey]

Try this:

=D$8*(VLOOKUP($E$9,$G$11:$H$20,2,0))

[ratcat]

Try this

Please Login or Register  to view this content.

[Haseeb Avarakkan]

Try:

=(1+VLOOKUP(E9,$G$11:$H$20,2,FALSE))*D8

[Treecko]

Wow, Thanks All. I didn't realize as being new at this that there would be more than one way to solve the problem.
I again bow to you and thank you all again.
Regards

[AlKey]

You're welcome and thank you for your feedback!