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.
![how to use vlookup in excel with drop down list mac how to use vlookup in excel with drop down list mac](https://www.skyneel.com/wp-content/uploads/2017/02/Advanced-VLookup-trick-with-Data-Validation-in-Excel-400x212.jpg)
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)
![how to use vlookup in excel with drop down list mac how to use vlookup in excel with drop down list mac](http://i.ytimg.com/vi/HZWSOAKO_9o/maxresdefault.jpg)
the member ID). Both VLOOKUP and XLOOKUP usually lookup (search for) a single value.
![how to use vlookup in excel with drop down list mac how to use vlookup in excel with drop down list mac](https://www.exceltip.com/wp-content/uploads/2014/11/image-1.png)
The value you want to find on the new list (e.g.