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))
This returns a value of 1, which is matched to the 1 that is used as the lookup value of the MATCH function, thus returning us the row where the conditions are met. Using the INDEX value, you can look for the value that is in the range C3:C13, which is in the row that was returned from the MATCH function.