Class Schedule
This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
home & schedule | syllabus | contact | grades
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.
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).
Start with your source material. Use sheets 11, 12,13, and 14 in your downloaded workbook.
Because your two tables are set up to be related, the function should populate all the way from row 2 (the 1st record) to row 1313 (the 1312th record)and show you the publisher names related to the publisher ID in column I on 11-tblBook.
week of 16 April labs | VLOOKUP | SQL creation