![]() ![]() ![]() In the example above, you would insert the VLOOKUP function into another spreadsheet with an item code, and it would return to you either the corresponding item’s description, its price, or its availability (its “In stock” quantity) as described in your original list. VLOOKUP retrieves information from a database/list based on a supplied instance of the unique identifier. So let’s see if we can get that clear first: The hardest part of using VLOOKUP is understanding exactly what it’s for. Our sample database above satisfies this criterion. Note: For the VLOOKUP function to work with a database/list, that list must have a column containing the unique identifier (or “key”, or “ID”), and that column must be the first column in the table. In this case, the unique identifier is in the “Item Code” column. ![]() Usually lists like this have some sort of unique identifier for each item in the list. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |