Another way to set up a range lookup table would be to create a second column for the maximum, and this range would have a minimum of 11 and a maximum of 20. The example shows that the discount for the purchase of 19 items is 2% because 19 falls between 11 and 21 in the Quantity column of the lookup table.Īs a result, VLOOKUP returns the value from the second column of the lookup table since that row contains the minimum of that range.
![vlookup with dropdown mac excel 2013 vlookup with dropdown mac excel 2013](https://i.pinimg.com/originals/32/aa/d5/32aad5694217b3a5a2db0dd963d974e7.jpg)
The example in the image above uses the VLOOKUP function to find the discount rate depending on the number of items purchased. Using the optional range_lookup argument is complicated for many people to understand, so it's worth looking at a quick example. The col_index_num argument is the resulting range value.The table_array contains all ranges and a column that contains the range value (such as high, medium, or low).The lookup_value is the value you want to check whether it falls inside a range defined by the table_array.If the range_lookup argument is TRUE, then: If omitted, the value is TRUE by default. The range_lookup argument is either "TRUE" or "FALSE." Use TRUE for an approximate match and FALSE for an exact match. Range_lookup (optional) - Indicates whether or not the lookup-value falls within a range contained in the table array. If you reference a number greater than the number of columns in the table array, the function will return the #REF! error.The first column must contain the lookup_valueĬol_index_num (required) - This is the column number of the value you want to find.The table_array must contain at least two columns of data.Table_array (required) - This is the table of data (a range of cells) that VLOOKUP searches to find the information you need. Lookup_value (required): The value to search for in the first column of the table array.
![vlookup with dropdown mac excel 2013 vlookup with dropdown mac excel 2013](https://i.ytimg.com/vi/1oRcpsuCC6w/maxresdefault.jpg)
The four arguments for the VLOOKUP function are as follows:
![vlookup with dropdown mac excel 2013 vlookup with dropdown mac excel 2013](https://www.lifewire.com/thmb/Gy5LWee-A_-L6NwxblU-r2ZpeCE=/3040x1664/filters:no_upscale():max_bytes(150000):strip_icc()/ExcelDropDownList1-a9a51700584a47abae97fcb9285ebfec.jpg)
The VLOOKUP function might look confusing because it contains four arguments, but it's straightforward to use. =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)