The XLOOKUP requires an entire range of values for this argument to indicate the array where the return value may be found. The VLOOKUP is easy to ‘break’ if this column number is hardcoded into the argument, which is an important benefit to the XLOOKUP. In a VLOOKUP this is a single number that refers back to the table array (the previous argument that indicated the entire range where the search value and returned value can be found). In our example, this would be the first name of the member. This argument indicates the range where the returned value can be found. Column index number (VLOOKUP) / Return array (XLOOKUP)
The lookup array can now be to the left or the right of the return value column and the XLOOKUP can act as a VLOOKUP or an HLOOKUP. The separation of the arrays makes the XLOOKUP much more flexible than the VLOOKUP.
The lookup array should house the value Excel will search for and the return array argument will house the value to be returned. The XLOOKUP separates the lookup array and the return array into two arguments. The next argument (return array) refers back to this array by indicating the relevant column number of the table array that houses the return value.Įxcel is programmed to search for the lookup value in the left column of this range and return a value to the right of this, indicated by the column number from the next argument. The VLOOKUP uses table_array, this area indicates the column for the lookup value and stretches to include the column for the returned value. This represents the biggest difference between VLOOKUP and XLOOKUP and in the example above will be the member’s dataset where you would find both the member (lookup value) and the member’s first name or last name (returned value). Table array (VLOOKUP) / Lookup array (XLOOKUP) the member ID). Both VLOOKUP and XLOOKUP usually lookup (search for) a single value. The value you want to find on the new list (e.g.
0 kommentar(er)
