VLOOKUP: Looking Up a Value
VLOOKUP(what, table, column, exact) looks for what in the first column of table and returns the value from the given column number of the same row. Use FALSE as the last argument for an exact match (nearly always what you want). If nothing matches you get #N/A; wrap it in IFERROR for a friendly message.
In this course each line of an example is one cell: the address, a colon, then what is in the cell. A line starting with = is a formula. Press Run to see the sheet with every formula worked out.
In `VLOOKUP(E1,A2:C4,3,FALSE)`, what does the 3 mean?
Look up the code in E1 and show its price (column 3) in F1.
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.