When you need to find some information in a large data-spreadsheet, or you need to search for the same kind of information throughout the spreadsheet use the Vlookup function.Ĭompany Salary Table which is managed by the financial team of the Company – In Company Salary Table, you start with a piece of information which is already known (or easily retrieved). Vlookup function applied between 2 different sheets placed in a same workbook.VLOOKUP for Approximate Matches (TRUE Keyword as the last parameter).In other words, it allows you to find (look up) a value from one column of data and returns it’s respective or corresponding value from another column. Vlookup (V stands for ‘Vertical’) is an in-built function in excel which allows establishing a relationship between different columns of excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |