How Vlookup to return the max value from multiple hits in Excel

How Vlookup to return the max value from multiple hits in Excel

We have several mathematical functions provided in or by Microsoft Excel. Some of these functions are; v-lookup, min, max, mean, mode, and median. They all have their basic function to perform in the excel sheet. V-lookup or vertical lookup as the name suggests is a mathematical function that does the searching of data in multiple