★0 XP
Question 1 of 10
The VLOOKUP function has 4 arguments:
1. The value you know
2. The range to search
3. How many columns to look to the right
4. Whether to use approximate match (this will be false if looking for an exact match)
Click into cell F2 and use the following formula to find the banana production of Paraguay:
=VLOOKUP("Paraguay", A:B, 2, FALSE)
Enter the resulting number into the field below to check your answer.
1. The value you know
2. The range to search
3. How many columns to look to the right
4. Whether to use approximate match (this will be false if looking for an exact match)
Click into cell F2 and use the following formula to find the banana production of Paraguay:
=VLOOKUP("Paraguay", A:B, 2, FALSE)
Enter the resulting number into the field below to check your answer.