Excel-Exercise-Free

1. This function is as useful as the function SUM. Each time you work with a table with 1 or several columns, you could be certain that you will use the function VLOOKUP. This function search for a value in the left most column of a table, and then returns a value in the same row from a column you specify in the table.

2. Let's start with this example. You have a table with 4 columns : in column 1 it's the country ISO code, in 2, the name of the country, in 3, the currency name and in 4 the currency value

3. The firt parameter is the value to be found in the first column of the array. The second is the table of information in which data is looked up.

Formule de la cellule

4. The third parameter is the column number in the table from which the matching value must be returned. So if you want to returns the name of the country, you put 2.

5. The last parameter is (normally) optional but with this function, it's compulsary to field it.
1 is the default value and that's means that function find an approximate match ( ???? NO WAY) So it's STRONGLY recommended to put 0 to find the exact match.

6. To return the name of the currency from its ISO code, you write this function

Formule de la cellule

7. To return the name of the currency from the country ISO code, you write this function

Formule de la cellule

8. And for the parity, the function is

Formule de la cellule

9. Could you realize this exercise