Tools for Information Literacy
VLookup Function
We used the VLOOKUP function earlier when we discussed functions, but we will repeat it here becasues of its relationship to relational databases.
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).
