Is_sorted: (Optional) For an exact match for your search key, write FALSE and for an approximate match for your search_key, write TRUE Index: The number of the column your piece of information is in relative to the range Range: The entire area on your spreadsheet to search within Search_key: The known value that corresponds to the information you’re looking for For example, if you have a spreadsheet with employee names and job titles, you can use VLOOKUP to answer questions like “What is Susie’s job title?” or “Who is the project manager?”īy the end of this tutorial, you will be able to use the VLOOKUP function to find a specific piece of information in your spreadsheet, and recognize when you might want to use an alternative function, such as HLOOKUP or XLOOKUP. You may use it to answer a specific question using your dataset. In Google Sheets, VLOOKUP is a function that enables you to quickly find a piece of information in your spreadsheet that’s related to a known piece of information.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |