Conclusion Returning the highest value in the same worksheet or different worksheets using the VLOOKUP function is discussed in this article.
VLOOKUP Wizard - easy way to write complex formulas The interactive will walk you through the configuration options to build a perfect formula for the criteria you specify.
These examples will teach you how to Vlookup multiple criteria, return a specific instance or all matches, do dynamic Vlookup in multiple sheets, and more.