The carcinoembryonic antigen (CEA) test measures the amount of this protein that may appear in the blood of some people who have certain kinds of cancers, especially cancer of the large intestine (colon and rectal cancer).
In this INDEX / MATCH example, the MATCH function will find the position of Jacket in column B, and the INDEX function will return the code from the same position in column A. Set up the worksheet as shown at right. Enter the following formula in cell B6: =INDEX($A$2:$A$4,MATCH(A6,$B$2:$B$4,0))
Excel Match Function Definition: Excel defines match function as: âReturns the relative position of an item in an array that matches a specified value in a specified orderâ. In simple plain language Match function searches for a value in a defined range and then returns its position.n the second example a Match formula with match type as -1 is used. The Result is: 4. This is because as the value 104 is not present in the array so the Match function points to the relative reference of a value slightly greater than 104 i.e. 105.