![]() ![]() It is used as the database function to perform calculations on the tables imported from the database. In the present article, the combined use of VLOOKUP VLOOKUP The VLOOKUP excel function searches for a particular value and returns a corresponding match based on a unique identifier. VLOOKUP is one of the advanced features of Excel Advanced Features Of Excel The top features of MS excel are - Shortcut keys, Summation of values, Data filtration, Paste special, Insert random numbers, Goal seek analysis tool, Insert serial numbers etc. Vlookup is a very versatile function which can be combined with other functions to get some desired result, one such situation is to calculate the sum of the data ( in numbers) based on the matching values, in such situations we can combine sum function with vlookup function, the method is as follows =SUM(Vlookup(reference value, table array, index number, match).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |