Tools for Information Literacy
VLookup Function
VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table.
It is an Excel way to do what SQL can do with a relational database.
What is VLOOKUP?
It's an Excel function that one may use when one needs to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.
In its simplest form, the VLOOKUP function says:
=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
