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))
By combining INDEX and MATCH we can produce the same result as VLOOKUP. Using the same search we did for VLOOKUP, the INDEX / MATCH pair looks like this: C4:H1159 is the array that INDEX uses to find the value. A2 is the cell that the value we want MATCH to find. C4:C1159 is the lookup_array that MATCH looks through to find the value in A2. The 0 means that MATCH will look for the exact value instead of an approximate one. Column 6 is the column in the C4:H1159 array that holds the Combined Fuel Economy values. The result is identical to the VLOOKUP result.