Now your bossy boss has sent you this list and asked for details in blank columns. To make it easy, I have taken a small table. Next, you have their designation and so on as shown in the image below. In the first column (Column A), you have the name of employees. In an Excel sheet, you have this data from employees. Let's jump into an Excel VLOOKUP example. : FALSE if you want to search for exact value, TRUE if you want an approximate match. Table_array: The Table in which you want to look up/searchĬol_index_number: The column number in Table Array from which you want to fetch results. Lookup_value:The value by which you want to search in the first column of Table Array. =VLOOKUP( lookup_value, table_array, col_index_number, )
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |