Tip: Try using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor.
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])
To download a reference card that explains what the arguments mean and how to use them, click the link below. The VLOOKUP reference card opens as a PDF file in Adobe Reader. Feel free to print a copy of the card, or save it somewhere on your computer to refer to later.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in the Answers community.
