![]() ![]() The LOOKUP function is not case-sensitive.Įxamples Example 1: Use LOOKUP function to find a value with one criterionĪs the below screenshot shown, you need to find Peach in the table range, and return the corresponding result in the Mon column, you can achieve it as follows. If there are multiple matched look_up values, it will match the last value.Ĥ. LOOKUP works based on approximate match, if the lookup value can’t be found exactly, it will match the next smallest value.ģ. If the lookup number is smaller than all values in the lookup range, it will return a #N/A error value.Ģ. The LOOKUP function will return a value in a one column range.ġ. It is a one-row or one-column data which has the same size with the lookup_vector. Result_vector (optional): The LOOKUP function searches for the value in the look_up vector, and returns the result from the same column or row position in the result_vector. ![]() Note: Values in this range must be sorted in ascending order, otherwise, LOOKUP might not return the correct value. The value in this argument can be numbers, text or logical values. Lookup_vector (required): A single row or single column range to be searched. It can be a number, a text or a reference to a cell containing the search value. Lookup_value (required): The value you will search for. It is only available in Excel for Microsoft 365. It finds things in a table or a range in any direction (up, down, left, right), which is more easier to use and works faster than other lookup functions. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |