You can insert the vlookup function from the Formulas menu in Excel. For example, in the given data set if you want to quickly find the number of public health centers for a particular state then this function can be modeled to extract only the required data from the entire data set. Also, another use of this functionality is that it can be used as a neat lookup form when many users are working on a particular data set. Vlookup is a handy function to search for specific data when there are many columns and rows in your data set.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |