[Solved] Determine tax rate, based on country

[Cobbles_Classics]

Hello all.
I am testing a workbook, with a section for different countries Sales tax / VAT rates.

TEST1 - displays the auto calculated results.

Column A - drop down list of Countries.
Column B - automated tax rate added, based upon which country is selected in column A.
Column C - manual column to add a value.
Column D - automated calculation, based upon the choice of Column A, which inputs a % in column B.
Column E - automated total calculation, based on input of column A, B, C.

DATA1 has a list of countries in column (A1:A39) and a corresponding list of tax rates in (B1:B39).

Working with sheet "TEST1" the goal is for a selected country, in column A, to auto add a corresponding tax rate into column B.
From this, the tax can be auto calculated in column C.

QUESTIONS:

is the most effective way to achieve this, by using data in other source ie "DATA1" and using the "IF" function?
or, have i approached this in an incorrect way ?

Kev

Edit: Changed subject, was Which option would be best?  Make your post understandable by others  -- MrProgrammer, forum moderator

[FJCC]

You should use the VLOOKUP() function. The formula in TEST1.B2 should be

Code: Select all

=VLOOKUP(A2;$DATA1.$A$1:$B$39;2;1)

You can then copy that down the rest of column B.

[Cobbles_Classics]

Thank you for your help. It is appreciated - I'd been looking at the wrong solution.