![]() ![]() 0 - find the first value in the array that is exactly equal to the lookup value.Requires sorting the lookup array in ascending order, from smallest to largest or from A to Z. 1 or omitted (default) - find the largest value in the lookup array that is less than or equal to the lookup value.The match_type argument set to 0 returns only the exact match, while the other two types allow for approximate match. Match_type (optional) - defines the match type. Lookup_array (required) - the range of cells to search in. It can be a numeric, text or logical value as well as a cell reference. Lookup_value (required) - the value you want to find.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |