This function allows you to search for exact matches, but it also supports approximate matches so even if your search parameters don't match exactly what's in your data set, VLOOKUP should still provide you with results that may be what you're looking for. Rangelookup (optional) = TRUE (approximate match), or FALSE (exact match)įor example, if you had collected a set of phone numbers from an event and you wanted to see whether any existing customers attended the event, you could use VLOOKUP to cross-reference event numbers with the numbers of your customers. Table_array = the range or table containing the lookup valueĬol_index_num = the column within the table from which to search for or retrieve the return value Lookup_value = the value you want to look for in the data set (first column) VLOOKUP syntax: =VLOOKUP ( lookup_value, table_array, col_index_num, )
VLOOKUP is a formula, or function, that allows you to look up and pull data into another vertically-organized data set based on specific criteria: Read more: 12 Excel Interview Questions and Answers to Help You Prepare What is VLOOKUP?
In this article, we explain what the VLOOKUP formula is including how and when to use it. Microsoft Excel, with its ability to create spreadsheets, is a great place to start when you have data to work with. You may have data that corresponds to sales numbers, employee salaries, customer satisfaction scores and more, and stakeholders often look at data curated to answer a specific question when making important business decisions. For many organizations, gathering, sorting and organizing data is a critical business practice.
0 kommentar(er)
