336 results about "Matching methods" patented technology

WorksheetFunction.Match method (Excel) Returns the relative position of an item in an array that matches a specified value in a specified order. 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. Syntax. expression A variable that represents a WorksheetFunction object.