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

We have several mathematical functions provided in or by the Microsoft Excel. Some of these functions are; v-lookup, min, max, mean, mode, and median. They all have their basic function…