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))
Then, the INDEX function, INDEX($A$2:$A$4,2), returns JK002, which is the second item in the range $A$2:$A$4. INDEX / MATCH -- Example 2 The MATCH function can be used to return values for both the row_num and column_num arguments in the INDEX function. 1  Set up the worksheet as shown above. 2  Enter the following formula in cell C7: =INDEX($B$2:$D$4,MATCH(B7,$A$2:$A$4,0),MATCH(A7,$B$1:$D$1,0)) 3  Press the Enter key to see the result.