![]() The lookup_value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value. ![]() ![]() For example, when you look up someone's number in a telephone book, you are using the person's name as the lookup value, but the telephone number is the value you want. The value that you want to match in lookup_array. The MATCH function syntax has the following arguments: For example, you might use the MATCH function to provide a value for the row_num argument of the INDEX function. Tip: Use MATCH instead of one of the LOOKUP functions when you need the position of an item in a range instead of the item itself.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |