A VLOOKUP looks for a value in the leftmost column of a table and then returns a value from the row that the searched for value is found (how far along that row is determined by you).
The 4 parts to a VLOOKUP formula:
- SearchFor this is the value that is being searched for. In our dictionary example it would be the word “elucidate”.
- WhereToSearch this is the range in which to search and in which the answer lives. In our example, it would be columns A to C.
- WhichColumn this is the column in the WhereToSearch range which has the answer in it. In our dictionary example, it would be the third column.
- NearOrExact you decide whether the VLOOKUP should search for a close value or an exact value (in our dictionary example we would set this to false as we do want it to search for the exact word “elucidate”).
Structure of the VLOOKUP formula:
=VLOOKUP ( SearchFor , WhereToSearch , WhichColumn , NearOrExact )
For our dictionary VLOOKUP example, see what the formula looks like below
Also see my blog post on “how to do a VLOOKUP on one page”
Want to get good at using the VLOOKUP function?
Download our practical VLOOKUP tutorial workbook with step-by-step instructions and examples to help you become a VLOOKUP pro.