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:

VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])

ZA101984673

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

 

Share →

Leave a Reply

Your email address will not be published. Required fields are marked *



For More Information

Call us to 954-633-2718 or email: hector@quickbooks-training.net