If you want to know how to return the highest value using the VLOOKUP function in Excel, you’ve landed on the right page. Let's say you have a sales dataset and you want to retrieve the highest value ...

There's a lot going on in these formulaic conditional rules in Microsoft Excel that highlight the smallest and largest values within a period of years.