A Simple Computer Library

Exercise 1 (VLOOKUP)
Please type Table 2 in cell A8.
Type Number, City in cell A9, Age in cell B9 and Age in cell C9.
Fill in 1 to 4 under Number column.
Type Miami, Ketchikan, Seattle and Vancouver under City column.
Type 34, 61, 23 and 45 under Age column.
For Table 1
Please type Number, Name, City, Age start in cell A1,B1 and so forth.
Fill in 1 to 4 and name under Number and Name column.
Please use VLOOKUP function to fill City and Age column.
The output result is below:

So the formulas that we use:
=VLOOKUP(A3;$A$10:$C$13;2)
=VLOOKUP(A3;$A$10:$C$13;3)