A VLOOKUP refresher

In Data Analysis in Google Sheets you learned how to use VLOOKUP(). They are important, so let's refresh your memory.

VLOOKUP() is like INDEX() in that it lets you look up values within a data block. It has the advantage that rather than you having to look and find the position of the cell to specify manually, you can specify the value you are looking for, and it automatically finds it. VLOOKUP() takes four arguments.

• First is the value that you are looking for, usually a string.
• Second is the data range, usually specified using absolute coordinates. The first column must contain the lookup values.
• Third is the column offset, the same as with INDEX().
• Fourth is whether or not the data is sorted by the lookup column. Usually you need to specify FALSE here.