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))
Used together with INDEX, MATCH can retrieve the value at the matched position. Match type information. 1  If match_type is 1, MATCH finds the largest value that is less than or equal to lookup_value. 2  The lookup_array must be sorted in ascending order. 3  If match_type is 0, MATCH finds the first value exactly equal to lookup_value. lookup_array does not need to be sorted.