VLOOKUP is one of the most popular, useful functions in Excel, but it’s hard to remember the formula if you don’t use it that often.
If all you want is the syntax for VLOOKUP, here it is:
PDF – VLOOKUP REFERENCE CARD REFRESHER
Also, if you use the VLOOKUP function to look up values in a list or table, it’s possible to end up with #N/A errors, particularly when you’re looking for exact matches. Although these errors are annoying, they occur for a good reason—either the value you’re trying to find doesn’t exist, or it does exist but Excel doesn’t perceive it as a match due to a formatting mismatch or other issue.
PDF – VLOOKUP REFERENCE CARD TROUBLESHOOTING TIPS