![]() The second step is to select the data where this info is available. VLOOKUP performs the search in the first column and retrieves the info from whichever column you specify to the right. As I mentioned before, this value needs to exist in the first column of your table. In this case, it is the Annual Salary of the employee with the ID number '4679'. The first step is to understand which data we want to retrieve. Determine if you need to use an exact match or an approximate match (setting the match_type).Select which info you want to retrieve (selecting the col_index_num).Understand for which data to perform the VLOOKUP (selecting the table_array).Identify which is the value that you want to use (finding the lookup_value).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |