VLOOKUP In Google Sheets

VLOOKUP is a massively powerful function that finds matches and returns information of the row where it has found these matches.
It works like so:
1. Step 1, write =VLOOKUP().
2. Step 2, specify WHAT you want to look for in the 1st column of that range.
3. Step 3, specify the RANGE of interest BUT note that VLOOKUP will only look for values in the first column of this range!
4. Step 4, specify WHICH COLUMN of the row where a match is found, you want to be returned.
5. Step 5, choose if the match should be exact (FALSE), or approximate (TRUE). Unless you have a very good reason not to, write FALSE here. It usually makes the function work better.
Now I can explain how my example at the start of the video works.
The functions to find the movie length and score are almost identical:
- Both look for the value which is in G2.
- Both use the range of B2 to E11.
- Both look for an exact match as noted by the FALSE statement or 0 at the end of the function
The one difference between the two functions are WHICH COLUMN they return. For the length of the movie, the 3rd column is returned and for the score, the 4th column is returned.