Test Answer Explanations: VLOOKUP in Excel Test INDEX-MATCH & VLOOKUP in ExcelFormulas in Excel – Look Up Data Excel 2010 Test – Working with Data Free Online Microsoft Excel Test10 Question Multiple Choice Quiz with Answers***GO TO THE TEST START
PAGE Show
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. Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. In its simplest form, the VLOOKUP function says: =VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
Tip: The secret to VLOOKUP is to organize your data so that the value you look up (Fruit) is to the left of the return value (Amount) you want to find. Use the VLOOKUP function to look up a value in a table. Syntax VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) For example:
How to get startedThere are four pieces of information that you will need in order to build the VLOOKUP syntax:
Now put all of the above together as follows: =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)). ExamplesHere are a few examples of VLOOKUP: Example 1Example 2Example 3Example 4Example 5You can use VLOOKUP to combine multiple tables into one, as long as one of the tables has fields in common with all the others. This can be especially useful if you need to share a workbook with people who have older versions of Excel that don't support data features with multiple tables as data sources - by combining the sources into one table and changing the data feature's data source to the new table, the data feature can be used in older Excel versions (provided the data feature itself is supported by the older version).
Need more help?You can always ask an expert in the Excel Tech Community or get support in the Answers community.
See Also Quick Reference Card: VLOOKUP
refresher What is the correct syntax for the VLOOKUP function?In its simplest form, the VLOOKUP function says: =VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
What are the arguments of the VLOOKUP function?The VLOOKUP function consists of three required arguments, in the following order: lookup value, table array, and column index number.
How many arguments are there in VLOOKUP function?You can specify any one of the four arguments to decide how the lookup value should be matched: 0 – Exact match, where the lookup_value should exactly match the value in the lookup_array. This is the default option. -1 – Looks for the exact match, but if it's found, returns the next smaller item/value.
What is the first argument in a VLOOKUP function?The first parameter in the VLOOKUP function is the value to search for in the table of data.
|