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))
So we end up with a formula looking like this: =INDEX(A1:G55,MATCH(J2,B:B,0) The MATCH function searches for the value in J2 (âJonesâ) in the database and then returns a number. This number is the number of the row in the data where the last name âJonesâ is found. This row number is then fed into the syntax of the INDEX function. Put a comma after the right parenthesis of the MATCH function. Then you can see the INDEX function tooltip change to highlight the [column_num].